How to export search results into Excel format

[hotflash]

Hi All,

Instead of displaying the search results such as names, phones, etc... on the screen, is there a way to export this information into an EXCEL format using ASP?

Please advise. Thanks for your help.

[DrBunchman]

Hi hotflash,

By search results do you mean a record set generated by a sql query? So you want to fill an excel file based on these results?

A quick google turned up this tutorial.

Please give it a go yourself and come back here if you get stuck with anything.

Let me know how you get on.

Dr B

[hotflash]

Hi DrB,

As always, thanks for your outstanding support.

I will look at the link you gave me. Meanwhile, to answer you questions.

1. The search results mean a record set generated by a SQL query. Same
thing you helped me out last time.

2. I want 2 options ... a. Display using HTML which WORKS fine now. b. Export the file to EXCEL.

Thanks for your help again and will try your link sometimes today.

[DrBunchman]

Okay hotflash, if you have any problems then post your code here and we'll try to help you out.

Good luck,

Dr B