pull in data from multiple excel worksheets

  • Thread starter Thread starter Ajay Sinha
  • Start date Start date
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
 
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
 
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...
 
You must log in or register to reply here.

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

Pulling data from a linked SQL table 2
Get data from Access db and put in a formatted Excel spreadsheet 12
Simultaneously pulling data from multiple databases 5
import multiple Excel worksheet into a main Access table 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
queries which pull data in multiple "rows" in one table and compar 2
Collate data from multiple workbooks into one worksheet 0
Q: Working with Embedded Excel Worksheets 2

Back
Top