linking to dbase file with long filename

[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

 

[Cindy Winegarden]

In news: (e-mail address removed),

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?

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.

 

[Chad Nielsen]

In news: (e-mail address removed),


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.

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".