How To ......

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all,

I have build a report generator which allow the end user to select some
criteria and some sorting option to open report according to he's needs by
clicking on a command button..
The main query I use is a Select with no WHERE or Order By clause which it
is already saved in the db.

What I need to do is to take that query export the data thru a command
button in Excel instead of running the report.On the Export, the user needs
the option to save the file wherever he want.

Can anyone point me into the right direction on how to do this

Many Thanks

Alain
 
Back
Top