Linking to Excel spreadsheet

[Hey]

Hi

I'm trying to link to a spreadsheet and then copy data from it to my table.
The 1st row of the spreadsheet has the field names on it, and some of the
column names are #Num1 instead of the name they should be. Hello? What
causes this, and how do I fix it so I have my column names for the
appropriate control names on a append query?
Thanks,
me

 

[Ken Snell MVP]

See this article:

Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or
when Linking to an EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#DataTypeErr

 

[Hey]

Ken,

My problem turned out to be even simpler. My transferspreadsheet command
was wrong. This link got me seeing that the transfer routine was seeing the
first column, 1st row as an error because it wasn't a number. Then I
noticed that the titles for all the columns were still F1,F2, etc and the
first row of data was the field name coming over from Row 1 of the
spreadsheet except the ones for the numberic fields were this #Num1 instead.
So, that first row where the titles were was the problem. I had put "Yes"
for first line being titles because in something I read it had said Yes/No,
is the 1st row titles. When I investigated further, I saw True/False,
changed my line to have "True" instead of "Yes" and it works like a champ.

I can see on my OP that I didn't explain it precisely enough for you to know
what was really going on, but your answer did cause me to delve further
instead of just seeing a problem.

Thanks for setting me on the path to discovery Ken!
me