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

Word Was Unable To Open The Data Source Word 2007

Contents

Which version of Windows? Last edited by krazykarter; Apr 26th, 2010 at 11:00 AM. using the mail merge toolbar in Word 2007 to select the mail merge document type "Normal Word Document" - in 2007, it's in one of the dropdowns in the Mailings tab. Also, the SQL statement is correct; I have run it in Query Analyzer and it returns the correct results. http://webinweb.net/data-source/word-2007-unable-to-open-data-source.html

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 The letters are created seperately in turn and then appended to each other as each letter has a unique barcode inserted so the mail merge data source is recreated by the a. ...an Access table, the "database" is the Access .mdb file that contains all the data, and the table is a table or query within that .mdb b. ...a text file, Please help!

Word Was Unable To Open The Data Source 2010

If you have not tried already, try opening your Excel document first, then making the connection. Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source." When I do find the source I return to the "Find" prompt again and again!!! I would be looking at the permissions for the /share/ and for the underlying folder - e.g.

Which version of Windows? The time now is 07:40 AM. I receive the error "Word cannot find the source ". Word Was Unable To Open The Data Source Mac Suppose you have { MERGEFIELD mypercentage } Select it, and press ctrl-F9 to surround it with a new pair of field code braces: { { MERGEFIELD mypercentage } } then insert

If there are any > > security issues, they will probably appear there. Simplifico replied Dec 23, 2016 at 7:15 AM Desktop freezes and stops... However, if I make a new csv file in notepad and make the names with an _, it works fine. By the way my Windows default is Internet Browser.

By the way my Windows default is Internet Browser. Word 2013 Mail Merge Unable To Open Data Source The preconditions are correct, i.e. Yu still > > need to specify the .odc in the Name parameter and the SQL statement, but > > you may find this works where the other approach does not. One or two people have reported that they have solved their DDE connection problems by changing their default Windows browser so that Internet Explorer is not the default.

Word 2013 Word Was Unable To Open The Datasource

are your mail merge document and data source in the same network folder? If the issue is in fact a program error, why would other letters generate successfully and this single template fail, when the file path and template name are correct, and the Word Was Unable To Open The Data Source 2010 Then I select the table "Sheet1$" without any errors. Word Was Unable To Open The Data Source 2016 No, create an account now.

Thread Status: Not open for further replies. have a peek at these guys This site is completely free -- paid for by advertisers and donations. Sign up now! Any help to correct this is greatly appreciated. Word Was Unable To Open The Data Source Word 2010

I have two .odc s here, getting table data from the same server (but different databases), apparently with identical connection strings. An application such as Word that uses OLE DB to get data usually specifies the database part of the data source's locatoin in a /Connection string/, and specifies the "table" part when using OLE DB, but not this one Also, blank fields in Excel dispay the value zero (0) when merged in Word. http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-excel-2007.html Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source."

If you see \*Mergeformat in there, delete it. Mail Merge Can't Open Data Source Two of the values in the view are dates. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

Try moving your Excel file (or making a copy) on your Desktop and also have your Word document there and try again.

I pass the .odc to OpenDataSource and leave connect string and SQL statement blank. I followed the suggestion of prompting the data source before opening and I can choose "MS Excel Worksheet via DDE (*.xls) when prompted. The error appears when batch letters are created in an application written in Delphi. Kingsoft Writer Cannot Open Data Source Specifically, numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word.

is cached in the .doc. But then I get the second clue. If it uses OLE DB, it generates a "connection string" which contains the path name of the folder containing the file. http://webinweb.net/data-source/word-is-unable-to-open-the-data-source.html unless you happen to know that 0 always means that the original entry was blank.

The problem ended up being solved by the following microsoft support doc. Specifically, they have mentioned making Firefox the default. Your name or email address: Do you already have an account? Should I > see records as well?

Does anyone have any ideas of things I could try to fix this? Also, blank fields in Excel dispay the value zero (0) when merged in Word. Another way to try to get the data as you see it in Excel is to Edit-Copy the data from the worksheet and paste it into a Word document, then use The next time the staff opens the document Word responds with 'Opening this document will run the following SQL Command' - as we would expect - but then we get a

Next I choose th named or cell range which is "Entire Spreadsheet". If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. How would I find out if it is? "Peter Jamieson" wrote: On Tuesday, August 21, 2007 5:12 PM Peter Jamieson wrote: Wen you have managed to open it, use Tools->Addins and Then, when I select "ok", it tells me that Word is unable to open the data source.

However, when I Finish & Merge, the data merged into Word look different than what it should and how it appears in Excel. Yu still need to specify the .odc in the Name parameter and the SQL statement, but you may find this works where the other approach does not. One displays records, the other does not.. Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source."

Please try again now or at a later time. Preview post Submit post Cancel post You are reporting the following post: "word was unable to open the data source" error message This post has been flagged and will be reviewed I tried the formatting suggestions, but when mail merged using OLE DB into word revealed instead of the percentage the following: Error ! Advertisement Recent Posts Driver for HP XW4400 Workstation Limon replied Dec 23, 2016 at 7:34 AM MBAM Popup Deke40 replied Dec 23, 2016 at 7:33 AM Sudden HP Laptop Failure sjdomin

I am not sure about all of the zeros in Word that should be there, but I know some originate from blank fileds formated as either General or Text in Excel. 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. On Thursday, July 31, 2008 9:55 PM Jerry Garnet wrote: Word 2003.