Access VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Access
  4. Importing Spreadsheet Data Using Code
Sub ImportSpreadsheet()
  DoCmd.TransferSpreadsheet _
    TransferType:=acImport, _
    SpreadsheetType:=acSpreadsheetTypeExcel12, _
    TableName:="Employees", _
    FileName:=CurrentProject.Path & "\Customer.Xls", _
    HasFieldNames:=True
End Sub