Err Msg : External table is not in the expected format.

[WhooTAZ]

A lady at work created an Access database that imports a dBase 5 file and when I go to import this file on User #1 PC it gives the error;

"External table is not in the expected format."

I can use the same Access database and same dBase file to import (stored on a shared network drive) from User #2 & #3's PC's and all works well. The only problem is that it is User #1 job to do this.

I unloaded Access 2003 and reloaded it and still the same results. All 3 PC's are identical via hardware and software.

It use to work until this past Tuesday when it started to give the error.

My steps are:
open the "Sales" Access database
select the prices table
Get External Data / Import and then select Prices.dbf
Then the error message comes up.

I am not an Access database guy and could use some help!

Thanks

WhooTAZ

 

[systemx]

Try importing it into a new table instead of an existing table. This will identify if the problem relates to the formatting of the table fields.

If the import to the new table works without error, then you need to look closely at how the fields are formatted in each table as I would hazard a guess that this is where the discrepancy is.

Regards,

Rob

 

[Dennisk]

this may a problem with the registry. Access sets up registry entries for those text files it will import. Maybe this is not correct on one PC.

or the format of the import file may have changed