DBF Import Into Access 2007

[eerich]

Is it possible to link or import a DBF table into Access 2007 ?

The import wizart doesnt seem to recognize my dbf file. Any help is appreciated.

 

[traingamer]

Is it a standard dbase or foxpro file? If so, Access should be able to link or import it natively.

What error(s), if any, are you getting?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[eerich]

The dbf tables are not from foxpro, but rather saved in that format in order to try and import into Access. Working with csv and tab delimited files we had errors because of user input that had similar characters in the description fields.

 

[traingamer]

The dbf tables are not from foxpro, but rather saved in that format in order to try and import into Access.

What is the original source of the data? (i.e. How are you saving it as .dbf if that isn't the original format?)

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[eerich]

Some of the data is being exported from a DB2/400 database and some from SQL Server 2005. The situation is that we have some folks on my team using Access 2003 and the DBF files can be linked or imported without an issue; however for those using Access 2007, we are unable to import or link the DBF files. It is not recognized. We've tried linking the data from Access 2003 directly, but Access 2007 would not recognize that format either.

 

[traingamer]

Haven't dealt with .dbf files since Access 2000, but found several references on the web, including one that said that there was a length limit of 8 characters on the file name:

http://deecay.blogspot.com/2008/02/more-on-importing-dbf-file-into.html

Hope that helps.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard