how can i save access Reports in Excel format. (1 Viewer)

[patelnitesha]

Hello,

I want to save Access Reports in Excel foramt. Can anyone guide me how i can do this. I use the Access 97 to generates reports. I can save them in ritch text format and in snapshot foramt. but i want to save them in Excel format or any other format which will be imported in the Sage 50. I want to import these reports in SAGE 50 . so any other foramt then i appreciate it too.


Thanks in advance..

Regards
Nitesha

 

[KenHigg]

You can use DoCmd.OutputTo to send the reports query results to a spreadsheet.

 

[patelnitesha]

thank you.
I will try that.
Thansk for quick reply.

Nitesha

 

[KenHigg]

Glad to help -

 

[patelnitesha]

I tried it. it also saves in Excel but no data..only with some text box names. no data at all. Could you please tel me how i can get all data in to this Excel file.


lost again..
Nitesha

 

[KenHigg]

Is your forms record source based on a prebuilt query?

 

[patelnitesha]

yes it is based on prebuild query.

 

[patelnitesha]

it is like here
DoCmd.OpenReport "tempServiceReport", A_PREVIEW, , G_REP_var1
DoCmd.OutputTo OutputReport, "tempservicereport"acFormatXLS, "ServiceReport.xls",_ True

where G_REP_var1 = "InvoiceNumber >= " & invfrom & " AND InvoiceNumber <= " & invto & ""
and the report has Record Source like
Record Source : SELECT * FROM joint_ledger WHERE (((joint_ledger.type)<20) OR ((joint_ledger.type)=21));