can't import a dbf file

D

denise

I'm trying to import two .dbf files into access 2000 for comparison. One will
import just fine, the other will not. It has message: External table is not
in the expected format. The bad file does have different characters in it
like the A with quote mark and the upside down ?, example:
129 51474 503 À 20071220H-RN-YOUTH
129 51474
77 ¿à 20071220H-RN-YOUTH

The file that imports correctly does not have these characters.
Can anyone help me with a a way to get the other file with the characters to
import? Thanks very much for any ideas.
 
D

denise

I have further information now. The file that I could import was created
using Foxpro driver. The file that will not import was created using dbase
driver. I still need help to set up the ODBC to get this file into Access.
Thanks for any ideas.
 

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

Access 2007 DBF File Name Length 0
VBA to Make a DBF File 0
Importing FoxPro free table, getting around "the field is too small to accept.." error 1
Corrupt PST 2x/week HELP! 0
Import a dbf database into existing access table? 2
damaged records in .dbf file 0
Import of DBF shows wrong chars 2
Access 2007 Import a DBF file 0

Top