pull in data from multiple excel worksheets

A

Ajay Sinha

I've got a number (30) workbooks all formatted the same way and I want to
pull data from a specific range of cells in each into Access. Is there an
easy way to do this, or do I have to format each spreadsheet and pull them
all together before importing.

TIA
 
T

Tony D'Ambra

Name the Ranges in th Worksheets and then use Import/Link Spreadsheet
Wizard(s). Create a Union query to join all tables.


Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
 
A

Ajay Sinha

Thanks for the advice, Tony.


Tony D'Ambra said:
Name the Ranges in th Worksheets and then use Import/Link Spreadsheet
Wizard(s). Create a Union query to join all tables.


Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
Click to expand...
 
Top