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
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