Using the TransferDatabase Method : Database Transfer « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. Database Transfer

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








Related examples in the same category

1.Importing Text Data Using Code
2.transfer database acExport
3.Importing Spreadsheet Data Using Code
4.Export database
5.Import database
6.Exporting to a Database