How to import .DBF file into ACCESS

[Metcare]

Hi ,

I am trying to import a .dbf file (3Mb) to Access 2000, my fisrt time to
import .dbf, I always import .XLS files,. I am not successful importing the
..dbf as I am getting this error:
"The microsoft engine jet cannot find the object . Make sure the object
exists and that you spell its name and the path correctly".

The icon of the file is on the list and I just select it , but still it
cannot locate it.
Greatly appreciate your help. Thanks in advance.

 

[Arvin Meyer [MVP]]

There may be a problem with the version of dbf file. There may also be a
problem with Access not finding the index file. If you continue to have
trouble, try saving the file as text or csv and import that.

 

[John W. Vinson]

Hi ,

I am trying to import a .dbf file (3Mb) to Access 2000, my fisrt time to
import .dbf, I always import .XLS files,. I am not successful importing the
.dbf as I am getting this error:
"The microsoft engine jet cannot find the object . Make sure the object
exists and that you spell its name and the path correctly".

The icon of the file is on the list and I just select it , but still it
cannot locate it.
Greatly appreciate your help. Thanks in advance.

How are you trying to import it? What specific steps?

What I'd do is use File... Get External Data... Import; change "Files of type"
to the correct version of dBase. There are several versions - dBase III, dBase
IV, dBase 5.0, FoxPro, Visual FoxPro all use the .dbf extension but the files
have different internal structure.

 

[Metcare]

Yes, that's what I did, I tried selecting the different .dbf file types, but
am not successful. We do not have FOXpro or DBase programs to open it and
save it to a .csv or .txt. We just received this file from our provider. I
tried opening it in EXCEL but got truncated after 60K+++ records where
downloaded, and this file contains more than 60K records. I don't think
EXCEL can download all the records as the file is too big. Thanks

 

[Arvin Meyer [MVP]]

Excel 2007 can handle about 1 million rows. It may be the way to get what
you need.

 

[Metcare]

Thank you for your advise.

Excel 2007 can handle about 1 million rows. It may be the way to get what
you need.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[vharris835]

I got this error message trying to import a table into Access 2003 also. I
changed the name of the dbase file to only have the 8 character naming
convention (eg. 12345678.dbf) and it imported successfully. Are you unable
to import files with long names?

Thank you for your advise.

 

[Metcare]

Dear Vharris835

It worked!!! I just changed the names of the database files to 8 characters
and was able to import successful. Can't believe how simple the solution is.
I 've been using the workaround solution by converting the .DBF files to .csv
using my Excel 2007 at home as I have 2003 version at work. Now I do not need
to bring them home , just rename the files and viola! able to import them.
Works like a charm!
Thank you everybody for your help.

 

[Douglas J. Steele]

Actually, it may not even be necessary to rename the file.

http://www.mvps.org/access/api/api0020.htm at "The Access Web" includes code
to return the short file name for any long file name. I believe you can
simply determine the short file name and use it.