August 19th, 2003, 03:16 PM
|
|
Junior Member
|
|
Join Date: Aug 2003
Location: Alaska
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Access & Excel
I am working with Access and Excel. I have about 10 Excel sheets that I need to move into 1 Access table. The catch is, each Excel sheet has different column headings. Some columns are in all the sheets while others are not. I need to know if there is a way to import the data from the Excel sheet. Do I need to build the table with all the columns and then import the data or will Access add the needed columns each time?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
