external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to access external data from more than one source.
Any help on how to do this would be fantastic.
 
I would like excel to reach out to a Access database that I specify at the
time it reaches out to get some external data.

Usually I get external data through the "get external data", but that only
connects to whatever datasource you initially choose. i'd like to be able to
choose which Access database I am pulling data from at the time I bring it
into Excel.

hope that helps,

Thanks,
Lou Sanderson.
 
I think we'll need a few details:

Multiple Sources:
Oracle and Access and Excel?
or multiple Access databases?
or more than one Excel workbook?
or multiple worksheets?

Using....Excel Functions? MS Query? VBA? Data Consolidate?
 
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

Switching ODBC sources in Excel 2007 1
External Data Toolbar permanently greyed out. 7
External Data Refresh Issues 0
Cloud Storage 11
Import External Data 3
How to manage new data with external data in Excel? 1
Pivot table change data source 1
External Data Refresh all just for one worksheet 3

Back
Top