Import from Excel

[Guest]

Good morning all:

I have a excel spreadsheet and a macro setup to TransferSpreadsheet to a
Table in my database. The issue i am having is everytime i run the macro, its
saying field F10- F... is missing in destination table. The spreadhseet
itself has columns A - I and row 1 is the field names (all field names are
listed in the table) while row 2 - 210 contain the actual data i'm trying to
import. The only way i've found around it is to add fields F10- F... to the
table but then i end up with a bunch of empty useless fileds in my talbe.
Anyone know why this is happening.

Your assistance is most appreciated!

 

[Ken Snell \(MVP\)]

Is the "Has Field Names" property set to Yes? Do the field names in the
EXCEL worksheet match exactly (name, spelling, and order) the field names in
the ACCESS table? You need to be able to answer both questions as "yes".

 

[Guest]

Ken thank you for the quick response.

Yes, i have the Has Field Names set to Yes and i've double checked and all
field names and order are the same in both places. I've seen that happen for
the F1 scenario but as far down as F10 and so on. Anything else you think be
causing this problem?

Thanks

 

[Ken Snell \(MVP\)]

Well, how about giving more details about what the table's field names are
(and the order), along with the names from row 1 of the EXCEL file. This
error almost always involves a mismatch of field names and EXCEL data.

Also, are you sure that the EXCEL worksheet's UsedRange is not at a column
to the right of the last column of data?