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
hope that helps,
"Ron Coderre" wrote:
> 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?