VBA code that will import an excel file but not the field label

[maupiti]

Access 2003.

What is the VBA code that will import an excel file but will not include the field name in the Excel file. If the Access table field name is different from the field name in the Excel spreadsheet it won 't import.

/////////////////////////////////////////////////////

DoCmd.TransferSpreadsheet acImport, 8, "AccessTableName", "FileAndPathName", 0, "SheetName!StartofRange:EndofRange"

 

[PHV]

A common way is to import the excel file into a temporary table and then play with an append query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886