Access report to excel

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
 
S

Steve Schapel

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