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!

[email protected]
 
Top