(AC2003, XL2003)
Can anyone explain how I can get the transferspreadsheet function to
upload a sheet that has number for the field names? Access converts the
field header to "F##".
In other words, my Excel sheet being uploaded has field names/headers
in row 1 (like "Header Title A", "Header Title B" , "1", "2", "3").
When importing using the TransferSpreadsheet function, the first two
header names are assigned/converted ok, but the numeric names are
incorrectly converted to "F3", "F4", "F5".
If I import the sheet using File, Get, Import..., the header names are
imported correctly (ie, as they appear on the Excel sheet). Why doesn't
the wizard do this right?
Is there another way to automate I could better automate the import
process while retaining the numeric header names (like when I use the
wizard as opposed to the function)?
Thanks for any suggestions!!