I need to get information from a dbf file and use this information in my database.
I have tried DoCmd.TransferDatabase acImport, "dBase III", strFilePath, acTable, strDBFFilename, strNewTableName, False
This works sometimes but not in all occassions.
I have tried linking these tables manually in mdb databse which works fine for all dbf files.
If there a way I can write some vba code in a adp project to read the dbf file in the same way a linked table works - perhaps by creating a connection to the dbf file?.