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)
 
Back
Top