Exporting Current Access data into Template?

T

TKM

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

Dave F

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

Dave
 

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

Access Queries into Excel 1
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5
Converting excel to PDF, single page converts to multiple HELP! 1
why do print range erase in Excel when import data from access 1
Export Data from Report or Query to Excel 1
Export Data from an access table to a pre-formatted excel template 1
Why is "export" greyed out in Access 2003 0
Formatting data from excel sheet 2

Top