Dim db As DAO.Database Dim tdf As DAO.TableDef Set db = OpenDatabase(strDBPath) strTableName=db.TableDefs(0).Name DoCmd.TransferDatabase acImport, "Microsoft Access", strDBPath, acTable,strTableName, "TempTable" db.Close
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)