I know the code to import dbf file to access
DoCmd.TransferDatabase acImport, "dBase 5.0", strLocalDir, acTable,
strFileName, strTableName
But how can I check before import so that duplicate table doesn't exist. If exist I'd like yo delete that first otherwise access create table1, table2, table3, so on.............
Start Free Trial