Importing .dbf files

G

Guest

Hello~

I have noticed this is a more common problem, but the solutions we have
found so far have not worked. We are trying to import a .dbf file that is
sent to us from another company. When we do we receive an error "External
table is not in the expected format." How do we get it into that format. I
see many things about drivers, etc. but so far we have had no luck. Any
guesses or suggestions would be wonderful. Thank you for your time.
 
I

Immanuel Sibero

Hi Angela,

A few things to look at:

- make sure related files are in the same folder as the dbf file (i.e. mdx
index file, dbt memo file)
- all filenames should use the 8.3 DOS rule.
- all fields in the dbf files should be alphanumeric and no more than 10
characters wide. (No special characters allowed)

HTH,
Immanuel Sibero
 

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

Importing DBF and appending to databse 3
Importing FoxPro 2.6 DBF Into Access 2007 1
Importing DBF Databases 18
can't import a dbf file 1
Import of dbase files 3
Importing dbf files from Microsoft Works 1
How do I import multiple .dbf files into Access 2007? 0
Macro to Import a DBF File 2

Top