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