Export Access Table Template to Tab in Excel Workbook

C

Chase

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

John Nurick

The term "standard table template" is new to me. What do you mean by it?
What sort of query are you referring to?
 
S

SeattleExcel

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

Password protect new workbooks from template 0
Embed the same Excel multiple times 0
I have a document with 8 different templates on it. 1
Consolidation Table from Different Excel Tabs with Different Format 1
Use a master workbook to carry over changes to multiple workbooks 1
Multiple templates with common styles 2
Confusion over where user templates are stored in Word 1
Using Access Database to build contracts with fields on pdf document 0

Top