I have an excel spreadsheet that currently has data in a somewhat non-standard format. The first Column contains all the "titles" and each column after that has data in it.
I need to import this information into Access but it doesnt give me the option to chose the first column as the header. (only first row)
Do any of you know of a way I can do this? Is there a way to "rotate" the data in excel so it fits the way Access wants to do the import??
Thanks!
I need to import this information into Access but it doesnt give me the option to chose the first column as the header. (only first row)
Do any of you know of a way I can do this? Is there a way to "rotate" the data in excel so it fits the way Access wants to do the import??
Thanks!
