Access report to excel

  • Thread starter Thread starter sojourner
  • Start date Start date
S

sojourner

How do I convert an access report to an excel file but with only certai
data going to the excel file.:confused:. And can the report be in
fixed excel format
 
Sojourner,

Make and save a Query that returns the data you want to export to the
spreadsheet. Then use the File|Export menu to do the export. If you
need to automate it, the TransferSpreadsheet statement is applicable.
 
You must log in or register to reply here.

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

Excel How to Fix Damaged Excel File That Won't Open? 3
Convert Access report to Excel workbook keeping the groupings 1
Access Report to Excel Worksheet 2
Transfering an Access Report to Excel 1
Problem with Excel charts in Access 2007 report 1
Excel Analyzing 3
Access report export to Excel 1
access graphs to excel?? 0

Back
Top