Importing DBF files into Access

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Hello,

I am trying to import a dbf table into access. I have no
problems with files that do not have memo fields, but
when they have a memo field (.dbt) I get the following
message when I attempt the import:

The Microsoft Jet database engine could not find the
object 'contracts.dbf'. Make sure the object exists and
that you spelled its name and the path correctly.

I suspect the problem with with the .dbt file. When I go
to help it says something about making sure that I have
the .dat files in the right place. I do.

I have imported these files into access 2000 and access
2003 Beta without any problems. I have MS Jet 4.0 SP8.

Regards,
Robin
 
Hi Robin,

This can happen if the file or any folders in the path have long names.
Try moving the dbf and dbt (and any index files) into a folder with a
short name (e.g. C:\dbase\) and shortening the file names to the old 8.3
pattern (e.g. CONTRCTS.DBF).
 

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

linking DBase Files 4
Import DBF files with MEMO fields 10
Access 2007 Import a DBF file 0
DBF Import 4
Creating an Access database file from a dbf (dbase) file 5
.dbf file import problems 2
Importing DBF files 2
Import a dbf database into existing access table? 2

Back
Top