asked on
Import Multiple Excel Worksheets to Access Database
Hey all,
I have an Excel workbook with 170 worksheets.. all worksheets are identical, except for the data.. I would like to import these worksheets to an Access table.. any ideas? Also the worksheet names are date serials, ie; 080701 = 2008-Jul-01, I have a 'Date' column in the Access table and would like that column populated with this date.
Thanks,
Bud
I have an Excel workbook with 170 worksheets.. all worksheets are identical, except for the data.. I would like to import these worksheets to an Access table.. any ideas? Also the worksheet names are date serials, ie; 080701 = 2008-Jul-01, I have a 'Date' column in the Access table and would like that column populated with this date.
Thanks,
Bud
DatabasesMicrosoft ExcelMicrosoft Access
Last Comment
BTognietti
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Wow capricorn, my solution was not as elegent or short. Kudos
ASKER
Excellent!
Thanks capricorn
Thanks capricorn