TransferSpreadsheet - Use first row as field names

**jgelpi16** · 02-23-2011, 11:39 AM

when using the TransferSpreadsheet method how do you tell Access to use the first row as headers for the table? Here is my current code...

Code:

DoCmd.TransferSpreadsheet acImport, , "tblOvertime_Import", vFilePath & vFileName

**jgelpi16** · 02-23-2011, 11:41 AM

So simple....

Notice the end of the code.

Original Code:

Code:

DoCmd.TransferSpreadsheet acImport, , "tblOvertime_Import", vFilePath & vFileName

New Code:

Code:

DoCmd.TransferSpreadsheet acImport, , "tblOvertime_Import", vFilePath & vFileName, True