exporting access 2007 to excel 2007

[Robbieb29]

Hi all

I have my database working correctly. I would like the user after entering all data
into the form and viewing the report. Export it to excel and then to delete all data from the form
in order to start entering new information.

Is this possible to do

Cheers rob

 

[Galaxiom]

There is more than one way but this one is versatile.
DoCmd.OutputTo
http://msdn.microsoft.com/en-us/library/aa141534(office.10).aspx

DoCmd.TransferSpreadsheet has different features.
http://msdn.microsoft.com/en-us/library/aa141565(office.10).aspx