BTognietti
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Wow capricorn, my solution was not as elegent or short. Kudos
ASKER
Excellent!
Thanks capricorn
Thanks capricorn