Word Was Unable To Open The Data Source

3- Confirm Data Source opens click show all and then select MS Excel Worksheets via DDExls If I open normally, using quotOLE DB Database Filesquot the entire file opens but I want to select Names that are in Column B, titled Name. 4- Click ok

Re MailMerge Word is Unable to Open Data Source Multiple forms call this same module to create different mail merge templates, all of which work properly except this one. I would assume the connection string is set somewhere else.

Word unable to open data source Word unable to open data source. If you're getting a quotWord unable to open data sourcequot error, it usually means that Word is having trouble connecting to the source of data for a mail merge or other data-driven feature. 1. Check Data Source File Ensure Accessibility Verify that the data sourc

Word 2007 - quotword was unable to open the data sourcequot Tom Koski Mailmerge 5 August 6th 08 0852 PM Word mail merge quotUnable to Obtain List of Tables from Data Sourcequot Stephen Ford Mailmerge 10 February 11th 08 0742 AM Excel merge into Wordquotunable to open data sourcequot STEVE Microsoft Word Help 3 September 21st 07 0258 PM

And more importantly I also can just open the Word.docx without Access even running!, and it will correctly and without any hesitation retrieve the data for populating the fields from the database stored on the same computer qry_02_Mobility. Word complains quotUnable to access data source.quot As with my original computer when triggering

Check whether the Confirm file format conversion on open option is checked. Click on OK. If the Confirm file format conversion on open option is unchecked, Word will automatically fetch the files from Excel. Otherwise, Word shows the Open data source options as depicted below. Tips To avoid the Word Mail Merge not fetching Excel files

Word cannot open data source. I'm trying to build an address book that I will print for my wife to use. I want to use Word's mail merge feature with an Excel spreadsheet as the data source. When I click quotSelect Recipients,quot I see my spreadsheet where I saved it Documents --gt MyDataSources. I see a preview of the list in the Preview pane.

When you store an .xlsx file in a shared folder and use it as data source in a Word mail merge, Word opens the .xlsx file exclusively. If another user tries to open a Word file that uses the same data source simultaneously, only read-only permissions can be granted, and therefore the request fails. Workaround

I have used the excel spreadsheet for this purpose before, but I get a message that quotword cannot open the data sourcequot. The excel file otherwise works normally, as does word itself. Status Not open for further replies. Solved word cannot open excel data source. Jump to Latest

Mary Nolan . As said in quotData sources you can use for a mail mergequot, quotImportant No matter what type of file you use as a data source, be sure to save it on your local computer or a file share saving at an HTTP location isn't supported for mail merge.quotBeside, you could try to go to FilegtOptionsgtAdvanced and scroll down to the General section of the dialog and check the box for Confirm file