Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no extension
Hello,
Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no extension
Word seems to connect to an extensionless Word document when I connect
/manually/ here. I suggest you create the registry item described in the following article, even though the title may not appear relevant: http://support.microsoft.com/kb/825765 Peter Jamieson "Derrick Smith" wrote in message ... Hello, Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no extension
What you are experiencing is normal. behaviour with Word 2003. It is all to
do with the way Word 2003 attaches merge to its data. Without the extension, there is insufficient information in a text file for Word to determine the type of converter required. You can see this by renaming to *.txt and note the extra conversion options that you get when manually attaching the data. Change the database to produce an output with a TXT extension. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Derrick Smith wrote: Hello, Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no extension
It doesn't work for me (whether the text file is comma or tab delimited) and
I already have that registry entry.? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: Word seems to connect to an extensionless Word document when I connect /manually/ here. I suggest you create the registry item described in the following article, even though the title may not appear relevant: http://support.microsoft.com/kb/825765 Peter Jamieson "Derrick Smith" wrote in message ... Hello, Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no exten
Thanks folks, the reg setting did work for me, the merge bar is live and all
data is read. Cheers for the help. "Graham Mayor" wrote: What you are experiencing is normal. behaviour with Word 2003. It is all to do with the way Word 2003 attaches merge to its data. Without the extension, there is insufficient information in a text file for Word to determine the type of converter required. You can see this by renaming to *.txt and note the extra conversion options that you get when manually attaching the data. Change the database to produce an output with a TXT extension. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Derrick Smith wrote: Hello, Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 was unable to open the data source file has no extension
Yes, I was wrongly looking at a .doc format file.
I would agree that having the applicition provide a .txt extension is a much better idea. However, if that is not possible, try a. check Word Tools|Options|General|"Confirm conversions at open" b. connect to the text file c. in Confirm Data Source, check "Show All" d. Select Text files (*.txt) e. if the connection succeeds, save the mail merge main document f. re-open (manually or programmatically) There may still be problems if a. Word thinks it needs to pop up its character encoding dialog or b. the connection is made programmatically, in whcih case it may be necessary to provide a Subtype parameter in OpenDataSource Some background... While it's true that Word's converters are associated with extensions, the extensions are primarily used by Word to determine which converters to ask for a conversion service. Word can ask a converter to try to perform a conversion regardless of the extension. The first thing the converter does is to decide whether or not it can convert the file Word is asking about - in some cases converters may refuse on the grounds that the extension is wrong but I suspect most of them actually examine some or all of the content and base their decision on that. The ODBC and OLEDB methods don't use "Word text converters" and the association between an ODBC driver or OLEDB provider and an extension is even hazier. For example, I don't think anything in Windows actually says "for this file type, use this OLE DB provider" even though some MS documentation suggests that that is what happens. For ODBC, there is typically some extension information in the Driver's descriptive name for those drivers that work with files rather than servers such as SQL Server, and it's possible that Word looks at those. Otherwise, I suspect Word always presents OLEDB as an option, then probably tries to use the Jet OLEDB provider if you choose the OLEDB option. In that case, there is a set of file extensions that Word or the provider can try to use to determine the correct "Engine Type". Unfortunately in the case of the Jet "Text Engine", there really does not seem to be a way to tell OLE DB that an extensionless file in the specified folder is a "table" in the text "database" specified by the folder name. Peter Jamieson "Graham Mayor" wrote in message ... It doesn't work for me (whether the text file is comma or tab delimited) and I already have that registry entry.? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: Word seems to connect to an extensionless Word document when I connect /manually/ here. I suggest you create the registry item described in the following article, even though the title may not appear relevant: http://support.microsoft.com/kb/825765 Peter Jamieson "Derrick Smith" wrote in message ... Hello, Our custom access database creates a merge file called "doc merge data" on users' pcs. This file has no extension. With Word 2000 or below the merge opens with a full merge toolbar. With Word 2003 it greys the toolbar out, and using the merge wizard the file returns "Word was unable to open the data source." I have ticked the confirm conversion at open option as suggested. If I rename the file so it has a .txt extension all works. I've read previous forum posts and all involve an extension on the file. Other than re-writing the access database, there must be another difference between Word versions if the file is okay in previous... Any ideas? Many thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open data source | Mailmerge | |||
trouble with mail merge, word was unable to open data source | Mailmerge | |||
Word was unable to open the data source. | Mailmerge | |||
Unable to open excel data source for word mail merge | Microsoft Word Help | |||
"Word was unable to open the Excel data source" Asp.net Mailmerge | Mailmerge |