Export Access Table Template to Tab in Excel Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I export a standard table template to a tab in an Excel workbook based
on the query that entered the data into the table template?
 
The term "standard table template" is new to me. What do you mean by it?
What sort of query are you referring to?
 
Hi Chase,

Depending on what you want to do ..

1 - Open up your Access Table
File/Export
Save As Type - xls (many version choices here)

2 - You could also leave your table in Access, and link
to the table in Excel via a Data-PivotTable or
Data-Import External Data-New DB Query

Hope this helps .. Cheers!

(e-mail address removed)
 

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

Exporting Data to One Excel Workbook to Several Worksheets 2
Exporting to a template 1
Export Data from an access table to a pre-formatted excel template 1
Export Data from Report or Query to Excel 1
Exporting to a template in Excel 1
Export to Excel causes field name issue 1
expoerting data to excel 1
Export Table in Excel in separated tab 4

Back
Top