By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Import Excel using Access Wizard

P: n/a
(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!!

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.