data from cell A1 is not imported?

  • Thread starter Thread starter Lesley
  • Start date Start date
L

Lesley

I have the following function listed below that should
import all data the resides in column A.

Function ImportXL5()
DoCmd.TransferSpreadsheet _
acImport, 5, "TestTable", "C:\TEMP\newlines.XLS", True
End Function

*** for some strange reason the data that is in cell A1
is not imported!. The rest of the datais all imported.

Is this a common problem with importing data from an
excel spreadsheet? - TIA.

Lesley.
 
I believe that you have set "Has Field Names" to true, so
Access should be using cell A1 as the fieldname for your
data, and should not be including it in the dataset. If
you want cell A1 in the dataset, try changing the last
option to false.
 
Back
Top