linking to dbase file with long filename

  • Thread starter Thread starter Chad Nielsen
  • Start date Start date
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
 
In news: (e-mail address removed),
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.
 
Cindy Winegarden said:
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.
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".
 
Back
Top