View Single Post
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

As far as I can tell, there is no way to get the dBase ODBC or Jet (Access)
drivers to read a file with a .srt extension.

The simplest approach is probably to rename the file back to a dbf.
Unfortunately, you can't simply add ".dbf" to the end of the name.

Another possible approach would be to use the Visual FoxPro ODBC driver
rather than the dBASE driver. This seems to work with Word 2003 with a dBASE
III format file but I cannot be sure that it works with other versions of
either WOrd or the .dbf format. You will need to set up an ODBC DSN using
the ODBC administrator. When you try to create a new Visual FoxPro DSN you
may see a message saying that you have to download the latest version of the
driver - if so, it is currently at

http://msdn.microsoft.com/vfoxpro/do...c/default.aspx

I haven't been able to get the Visual FoxPro OLEDB provider to work with
files named .srt

Peter Jamieson

"auroracrum" wrote in message
...
I am attempting to perform a mail merge on a dbf type file. The vendor
that
created the file uses different file extensions because they use the same
file name for different purposes (i.e. original file is file.dbf a sorted
file is file.srt).
I attach the file with the srt extension to the mail merge document and
when
asked choose that the file is dbf type. The document states that it is
attached to the srt file but when I print the file is actually attached to
the file with the dbf extension on it.

Any ideas out there as to why that happens and how I may get attached to
the
file with the srt extension on it.

Thanks