Thanks for the info but the problem is that I have over 2500 Excel files I need to import into Access and I want to do that programmaticall y. If I can find a way to transpose the first column into the first row and the second column into the second row I will be very happy.
Thanks again for the quick response..
kinda
Last Activity: Sep 22 '06, 08:50 PM
Joined: Aug 31 '06
Location:
-
Importing Excel data to Access
Hi All,
I have an Excel spreadsheet that I need to import to Access. I used the DoCmd.TransferS preadSheet command but the problem I am facing is that all the field names are in Colums A1 to A15 and the data is in Columns B1 to B15. This is unlike the regular way of storing data where the fieldnames are across from A1 to P1 and the data is at the row level. Can anybody help me out?
Thanks.
Kinda.
No activity results to display
Leave a comment: