Importing Spreadsheet Data Using Code : Database Transfer « Access « VBA / Excel / Access / Word






Importing Spreadsheet Data Using Code

 
Sub ImportSpreadsheet()
  DoCmd.TransferSpreadsheet _
    TransferType:=acImport, _
    SpreadsheetType:=acSpreadsheetTypeExcel12, _
    TableName:="Employees", _
    FileName:=CurrentProject.Path & "\Customer.Xls", _
    HasFieldNames:=True
End Sub

 








Related examples in the same category

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