Connecting to DBF files

sdbsadmin

Registered User.
Local time
Yesterday, 20:38
Joined
Jun 6, 2013
Messages
14
We have a program that we're trying to extract information from to migrate to a new program.

I have the dbf files, but am not having any luck getting Access to connect to them. I tried making an ODBC driver, but it didn't like that (can't use ODBC for an Access or ISAM database). I tried importing it as a dBase, but it didn't like that either (file not in expected format), so I'm stuck.

Can anyone help me?

Thanks!
 
What version of Access are you using? Access 2013 doesn't support dbf files directly anymore. You can try doing this:
Open the .dbf file in Excel and resave it as a .csv file and then import from that.
 
It doesn't come into Excel in a normal format. It's all condensed onto one or two lines. I ended up buying DBF Converter, which turned them into Excel files for you me.

Thanks!
 

Users who are viewing this thread

Back
Top Bottom