Importing DBF files into Access

[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

 

[John Nurick]

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