TRANSFER SLQ-SELECT TO EXCEL

[kriss]

I want to do a query in Forms and output the results to an Excel sheet, not to a report as I have been doing. How do I go about it?

 

[krindler]

Hello...There is a lot of good example code out on the website that has been very beneficial to me. There are a couple of things you can do. Do a keyword search on 'OLE2' as well as 'OLE2 and Excel'. This should bring up a few things that will help you out. You can also do a keyword search, and on the bottom of the page you can change the 'Fields' section and click on 'Handle'. Enter in my handle, 'krindler' and that will bring up anything that I have entered in. There is a lot of example code on that as well.

Thanks!