I'm trying to import an Excel file into a Table in my application using
DoCmd.TransferSpreadsheet , , "Ledger_Import", strFileName
It is giving me an error that says "F1 is not in Ledger_Import" but there is no F1 column heading in the Excel sheet. Can I use a saved import specification to identify which columns are text and which are numbers and to make the upload go smoothly? Any other suggestions welcomed.