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).
 
Back
Top