Microsoft Office Forums "word was unable to open the data source" error

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2014, 12:02 PM
meganadand meganadand is offline "word was unable to open the data source" error Windows 7 64bit "word was unable to open the data source" error Office 2010 64bit
Novice
"word was unable to open the data source" error
 
Join Date: Jan 2014
Posts: 3
meganadand is on a distinguished road
Exclamation "word was unable to open the data source" error

Hi,



I have used a specific file the last 4 months for my mail merge. All of a sudden it stopped working... ??? I didn't do anything different that I have before. When I try to import the data into mail merge, none of my tables show up (see attachment). Then, when I select "ok", it tells me that Word is unable to open the data source.

Any suggestions???

Thanks!
Attached Images
File Type: jpg 2014-03-14 13_56_08-Document1 - Microsoft Word.jpg (16.2 KB, 14 views)
Reply With Quote
  #2  
Old 03-14-2014, 12:23 PM
macropod's Avatar
macropod macropod is offline "word was unable to open the data source" error Windows 7 32bit "word was unable to open the data source" error Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,535
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I note your profile says you're using Office 2010, but the error message refers to an .xls format worksheet, which is the older format. Are you sure your workbook is still in the .xls format and hasn't been changed to the newer .xlsx format?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-14-2014, 12:35 PM
meganadand meganadand is offline "word was unable to open the data source" error Windows 7 64bit "word was unable to open the data source" error Office 2010 64bit
Novice
"word was unable to open the data source" error
 
Join Date: Jan 2014
Posts: 3
meganadand is on a distinguished road
Default

You're right. The error message refers to an .xls format, but the document is in and .xlsx format. What do I need to do to fix it and why did that change?
Here are the document properties:
Attached Images
File Type: jpg 2014-03-14 14_30_41-Microsoft Excel - Mail Merge.jpg (32.8 KB, 13 views)
Reply With Quote
  #4  
Old 03-14-2014, 12:40 PM
macropod's Avatar
macropod macropod is offline "word was unable to open the data source" error Windows 7 32bit "word was unable to open the data source" error Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,535
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Simply select the correct file as the data source, save the updated file, then continue as before. For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the file extension.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-14-2014, 12:45 PM
meganadand meganadand is offline "word was unable to open the data source" error Windows 7 64bit "word was unable to open the data source" error Office 2010 64bit
Novice
"word was unable to open the data source" error
 
Join Date: Jan 2014
Posts: 3
meganadand is on a distinguished road
Default

Thanks, but I already tried that - it won't let me edit the file extension. Any other suggestions?
Reply With Quote
  #6  
Old 03-14-2014, 01:12 PM
macropod's Avatar
macropod macropod is offline "word was unable to open the data source" error Windows 7 32bit "word was unable to open the data source" error Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,535
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The 'Connections' panel on that dialogue allow you to change the entire file path & name, if need be. If you can't get things to work that way, simply answer 'No' to the initial SQL prompt when you open the document, then use 'Select Recipients' on the Mailings tab to navigate to and select the correct workbook.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
excel 2010, mail merge problem, word 2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: "Changes made were lost...reconnect with server", when switching "from" field randhurrle Outlook 2 02-25-2015 06:51 PM
"word was unable to open the data source" error "Unable to display the folder" error on viwing another Mailbox AlexTeslin Outlook 2 10-21-2013 09:30 AM
"word was unable to open the data source" error Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
"word was unable to open the data source" error Word 2003 "The information you were working on might be lost" constant error message rocketbeta Word 1 08-21-2012 02:54 PM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM


All times are GMT -7. The time now is 08:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft