Connecting to DBF files

[sdbsadmin]

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!

 

[boblarson]

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.

 

[sdbsadmin]

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!