Still having problem with merging with DBF files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HD - 06 Mar 2006 14:20 GMT

Hi there,

I was having problem merging a Word file with a DBF file. After many hours
and a few messages to this newsgroup, I installed VFPODBC.msi, which
installed itself in the System DSN tab of the ODBC Administrator... I
finally found out that the drivers needed to be installed in the User DSN...
which is what I did... I added them in the User DSN tab using exactly the
same names and
driver... and now the merge between Word and DBF works... almost...
the merge works only with DBF files that do NOT have memo fields... As soon
as my DBF file has a memo field, I'm back where I started again... it gives
me a message : "Word was unable to open the data source".

Anybody has any idea as to why it does that??... I REALLY would appreciate
the input.

H. Dumas

Reply to this Message

Peter Jamieson - 06 Mar 2006 23:42 GMT

I don't know whether you will be able to see the memo fields in a merge, but
I do think you should read through what I said last time (I have repeated it
below) partly because of the possibility that the FoxPro driver is actually
the wrong one
for your .dbf - in other words, there may need to be a change to the Win2003
server.

Peter Jamieson

> I think there are two main possible problems here:
> a. you may only be able to connect programmatically and
[quoted text clipped - 16 lines]
>
> If you can open the DBF in Excel, it suggests that Word ought to be able

> use the FoxPro driver. I would proceeed as follows:
>
[quoted text clipped - 11 lines]
>
> Then, if possible, try opening the data source in VBA code using the

FoxPro

> driver. An example of the syntax you need for a .dbf with a FoxPro ODBC
> User/System DSN is
[quoted text clipped - 13 lines]
>
> Peter Jamieson

> Hi there,
>
[quoted text clipped - 17 lines]
>
> H. Dumas

Reply to this Message