linking to dbase file with long filename

C

Chad Nielsen

Hello,

I need to be able to use Access to link to a Dbase file but cannot
because the filename is too long. Changing the filename is not an
option. Is there a way around this without changing filename? I
thought maybe setting up an ODBC connection to the dbase file but
apparently this is not possible. Or is it?

TIA,
Chad
 
C

Cindy Winegarden

In news: [email protected],
Chad Nielsen said:
I need to be able to use Access to link to a Dbase file but cannot
because the filename is too long. Changing the filename is not an
option. Is there a way around this without changing filename? I
thought maybe setting up an ODBC connection to the dbase file but
apparently this is not possible. Or is it?
Click to expand...

Hi Chad,

You may be able to read your file with the Microsoft Visual FoxPro ODBC
driver, available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx. There's
also a VFP OLE DB provider, which may be another option.
 
C

Chad Nielsen

Cindy Winegarden said:
In news: [email protected],


Hi Chad,

You may be able to read your file with the Microsoft Visual FoxPro ODBC
driver, available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx. There's
also a VFP OLE DB provider, which may be another option.
Click to expand...

Thanks Cindy,
I was able to set up the ODBC connection using the MS Visual FoxPro
ODBC driver. The fieldnames are coming across fine but every field is
filled with "#Name?" and there is a warning "ODBC call failed".
 
Top