external data

L

lou sanderson

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

lou sanderson

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

Ron Coderre

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