Mass Excel to Access (or Oracle)

N

Nigel Webster

I have about 40 Excel spreadsheets (workbooks) with about 25 worksheets
each - total of about 1000 worksheets.
I know how to import Excel into Access one at a time.

I'm wondering if anyone knows of any good import tools which would
automatically drill through the various spreadsheets/worksheets and pull the
data into MS Access - or alteratively, into Oracle without significant user
input along the way?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Accessibility 0
Using MS Access to Manipulate Excel Workbook 1
Get Excel Worksheet Names for Importing into Access Tables 4
Excel 2010 Table not showing in Access 2010 Import List 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Use Access VBA to run an Excel sub routine 1
Trying to automatically import specific data from Excel into Word: 1
VBA Macro Training in Chennai 0

Top