Importing DBF in Access = PROBLEM, EXCEL = NO PROBLEM, Why ?

  • Thread starter Thread starter Jürgen Germonpré
  • Start date Start date
J

Jürgen Germonpré

Hi all,

Clients often send me database exports for direct mailing purposes. Most of
the times the format is TXT (delimited) or excel/access files so importing
the data is done quite fast. However, sometimes I do get DBF files, and
everytime I use the Get external data feature I get the following message:

"The Microsoft Jet Database engine could not find the object 'file.dbf'.
Make sure the object exists and that you spell its name and the path name
correctly."

I checked it and there no problem with the filenames and paths. When I do
the same routine with Excel there's no problem at all!!! I just don't dig
it. Why would the Access DBF importer stall on the file while Excel's
doesn't.

I just can't figure out how to get the data into Access 2002 directly
instead of bypassing it to Excel first...
Any ideas ? Help would be more than welcome.

Jürgen Germonpré
 
Problem solved:

The dBase import routine seems to need old-style 8.3 filenames and
paths. Either specify the short equivalent of the path or move and
rename the file so there are no long names in the path and its total
length is less than 64 characters.

Thanks to Mr. John Nurick
 
Back
Top