Exporting Current Access data into Template?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKM - 14 Nov 2006 18:44 GMT

Can I export my queries into a preformatted Excel Template? I ave tried all
day with little results. I have three seprate queries. I use the transfer
spreadsheet and the range in Access. But for some resons I cant get Excel to
hold all the formatting and basic Sumarry of my queries. All I need is for
user to push a button and see my queries in a Excel format with three tabs at
the bottom. What am I doing wrong?

Reply to this Message

Dave F - 14 Nov 2006 19:28 GMT

Why don't you pull the queries from Access via Excel's "get external data"
tool? Data--External Data.

Dave

Signature

Brevity is the soul of wit.

> Can I export my queries into a preformatted Excel Template? I ave tried all
> day with little results. I have three seprate queries. I use the transfer
> spreadsheet and the range in Access. But for some resons I cant get Excel to
> hold all the formatting and basic Sumarry of my queries. All I need is for
> user to push a button and see my queries in a Excel format with three tabs at
> the bottom. What am I doing wrong?

Reply to this Message