How to point Excel template to an Access database

[kopja]

Hi there.
I have an Excel template which pulls info from an access database and puts into a spreadsheet.
I'm just trying to get the template to point to another mdb file and I don't see where to do that.

Any help would be appreciated.

 

[PHV]

Have a look at QueryTables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kopja]

Sorry, could you be more specific?
I really don't know much about excel templates.

Thanls

 

[kopja]

I did find it, thanks for your help.

 

[SkipVought]

Data/Get External Data/new database Query......

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}