Mega Code Archive

 

Categories / VisualBasic Script / Access

 

Using the TransferDatabase Method

Sub ImportDatabase()   DoCmd.TransferDatabase _     TransferType:=acImport, _     DatabaseType:="dBASE III", _     DatabaseName:=CurrentProject.Path, _     ObjectType:=acTable, _     Source:="Employees", _     Destination:="tblCustomers", _     StructureOnly:=False End Sub