Home > Data Source > Word Was Unable To Open The Data Source Excel 2007

Word Was Unable To Open The Data Source Excel 2007

Contents

I wonder whether on that system, the ACE (Access) OLE DB provider that Word would normally use to open an Excel workbook is actually installed, or disabled in some way. (I Hopefully, Tom -- Thomas Koski Coastline Exploration, Inc. Privacy Policy Ad Choice Terms of Use Mobile User Agreement cnet Reviews All Reviews Audio Cameras Laptops Phones Roadshow Smart Home Tablets TVs News All News Apple Crave Internet Microsoft Mobile No, create an account now. weblink

Sorry, there was a problem flagging this post. are your mail merge document and data source in the same network folder? All of the individual suite applications are supported here, so please post your question in the relevant section for help. If I start with the original file, it works.

Word Was Unable To Open The Data Source 2013

The application is a C# windows forms app. If I attached a data source that's on my local drive to the word file, there is no problem - the merge file with the new data source saves fine. This site is completely free -- paid for by advertisers and donations. Reply With Quote Apr 26th, 2010,11:31 AM #6 krazykarter View Profile View Forum Posts Thread Starter Junior Member Join Date Jan 2010 Posts 28 Re: MailMerge: Word is Unable to Open

In the Select recipients section of the Mail Merge Wizard (Step 3 of 6), I select the Data Source by browsing to the location of the this .txt file on my You could see if the ACE provider is there by going to Word Select Recipients-Use existing list-New Source, select other/Advanced, click Next, and see if the ACE provider is listed. However, when I use a path like \\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1accept43\word_us I still get asked to confirm the data source when opening the template but it doesn't recognise this path and asks me to Word 2013 Mail Merge Unable To Open Data Source Last edited by krazykarter; Apr 26th, 2010 at 11:00 AM.

If you save as .htm I think it looks more as if enough info. If there are any > security issues, they will probably appear there. If there are any security issues, they will probably appear there. The string will be saved either in the connection string, or in the SQLStatement, or split across the two, depending on how Word chose to make the connection (it may choose

You will lose sorts and filters, and you have obviously lost the document type, but you do not lose the field codes. Mail Merge Can't Open Data Source You may have to register before you can post: click the register link above to proceed. Your cache administrator is webmaster. We cannot save the Word merge file with the correct data source attached.

Word Was Unable To Open The Data Source 2016

A simple test to ensure that it isn't simply /all/ Mail merge data sources that fail would be to copy/paste your Excel table into a Word document, save and close, then But if I select the file name in Windows explorer, right click and choose Analyze in Excel, Excel displays the table data in both cases. -- Peter Jamieson MS Word MVP Word Was Unable To Open The Data Source 2013 Mike "Peter Jamieson" wrote: On Friday, September 28, 2007 2:59 AM Peter Jamieson wrote: Is this also Word 2007? -- Peter Jamieson http://tips.pjmsn.me.uk On Friday, September 28, 2007 9:56 AM MikeDiCani Word Was Unable To Open The Data Source Word 2010 However, things are complicated by the fact that Word has a number of different mechanisms for opening a .tx or .csv type file and chooses the mechanism depending on the file

Word seems to be quite fussy about the SQL syntax - queries that work > elsewhere may fail in Word. have a peek at these guys Microsoft Office Forums > Microsoft Word > Mail Merge "word was unable to open the data source" error User Name Remember Me? I'm using the same .ODC file anyway, so if it works manually, it should also work when automated. Word data file You can use a Word document as a data source. Word Was Unable To Open The Data Source Mac

Mike "Peter Jamieson" wrote: On Friday, October 12, 2007 12:53 PM Peter Jamieson wrote: 1. This is the only error I get when trying to open an excel data source in Word 2007 mailmerge document. For more information, see Use Outlook contacts as a data source for a mail merge. check over here It really is just a couple of function calls - arghhh! > > > > > > I think I've tried just about every conceivable parameter combination > > > but

I don't work for Microsoft or have have access to the source code, so I have to guess, but in Word 2002(XP) and 2003, I believe Word will either use Word's Word Was Unable To Open The Data Source Mail Merge 2010 Peter Jamieson View Public Profile View message headers Find all posts by Peter Jamieson Find all threads started by Peter Jamieson #3 August 6th 08, 07:52 PM posted to I've tried putting the csv file in the My Data Sources folder and that doesn't fix it.

Word seems to be quite fussy about the SQL syntax - queries that work > > elsewhere may fail in Word.

Facebook Twitter Google+ YouTube LinkedIn Tumblr Pinterest Newsletters RSS Log in or Sign up Microsoft Office Forums Forums > Archive > Newsgroup Archive > Word Newsgroups > Word Mail Merge > Follow the prompts in the Data Connection Wizard to complete the data connection to the merge document. A simple test to ensure that it isn't simply /all/ Mail merge data sources that fail would be to copy/paste your Excel table into a Word document, save and close, then Kingsoft Writer Cannot Open Data Source For more information, see Use mail merge to send Access data to Word.

The document should contain a single table. This is why I think it has to do with the actual settings of the word template itself rather than the code: 1. Microsoft Outlook Contact List You can retrieve contact information directly from your Outlook Contact List in Word. this content Other database files You can use other data sources for a mail merge.

If I have to I will call Microsoft. It drives me crazy, as I am trying to give our folks in the field instructions on how to use mail merge and they get varying junkie results, including for the have any sorts or filters been applied to the data? -- Peter Jamieson http://tips.pjmsn.me.uk "Jane" <[email protected]> wrote in message news:[email protected] On Tuesday, August 21, 2007 7:42 AM Jan wrote: 1. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More...

The spreadsheet is a simple single sheet workbook with 10 columns and 9 rows, although I have tried it with more complex multi-sheet workbooks, with the same results. so, i took the table in my data document and copied the data (but not really the table) into a table in a new document. Word 2007 - "word was unable to open the data source" « Previous Thread | Next Thread » Thread Tools Display Modes #1 August 6th 08, 01:58 A simple test to ensure that it isn't simply /all/ Mail merge data sources that fail would be to copy/paste your Excel table into a Word document, save and close, then