This is my first post in the Access forum, as I am an Access newbie. So, please let me know if you need more info from me, but also, please be as explicit as possible since I just know enough to be dangerous. Having said that, I DO understand VBA as it relates to Excel so I will probably understand concepts...
Anyway, my issue is that I have to import a table that is well over 1,000 columns wide. However, the original data does not have column headers (field names) attached- those are in another Excel file, arranged vertically in Column D, with row number equal to the field number in Access. Make sense?
So, I need a a way to rename those fields according to the field names in the Excel file... I'm sure there's a way, besides keying them in manually ... any ideas?
Thanks in advance for any and all help!
Anyway, my issue is that I have to import a table that is well over 1,000 columns wide. However, the original data does not have column headers (field names) attached- those are in another Excel file, arranged vertically in Column D, with row number equal to the field number in Access. Make sense?
So, I need a a way to rename those fields according to the field names in the Excel file... I'm sure there's a way, besides keying them in manually ... any ideas?
Thanks in advance for any and all help!