convert report to excel file

[cl159037]

i m using access 2007. i want to know how to export my report to excel file since my excel file icon is disabled in the access tootbar.

 

[vbaInet]

In the Click event of a button you can use:

DoCmd.OutputTo

http://msdn.microsoft.com/en-us/library/bb238050(v=office.12).aspx
http://www.blueclaw-db.com/docmd_outputto_example.htm

Or

Export the Record Source of the report to a spreadsheet using:

DoCmd.TransferSpreadsheet:

http://msdn.microsoft.com/en-us/library/bb214134(v=office.12).aspx

 

[cl159037]

I m using access 2007, can anyone help me to transfer tabular access report to excel / spreadsheet file.

 

[vbaInet]

You double posted in error.

Look into the Import & Export wizard. You can use that to export your report to Excel.