How to import .DBF file into ACCESS

M

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

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

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

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
 
A

Arvin Meyer [MVP]

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

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?



Metcare said:
Thank you for your advise.
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top