Mega Code Archive

 

Categories / VisualBasic Script / Access

 

Importing Spreadsheet Data Using Code

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