data from cell A1 is not imported?

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.
 
T

Ted

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing multiple work sheets from a single excel Workbook 1
Possible to import a specific sheets data from excel into access? 1
how do I check if a field exists and create it if not? 0
Import Several excel files into Several Access Tables 6
Module Import error: Compile err 1
TransferSpreadsheet method 3
Excel file won't import unless open 1
Problem Importing Specific Worksheet From Workbook 6

Top