Import from excel ONLY specific headers

G

G Love

Hi,

I have 9 excel workbooks, each contains approximately 22 worksheets -
Total ~ 200 worksheets.

Each worksheet has varying numbers of columns, each column has a
header
Not every worksheet contains every header BUT does contain the headers
for the data I need to import to Access.
I want to extract 10 specific columns from each sheet into 1 master
database table but I have no idea how to do this... any pointers will
be much appreciated.

Thanks,

pglove :)
 

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

Top