Hi All,
I was wondering if someone could tell me how to export data to excel. I've looked in the FAQ and can't seem to find anything there on the topic.
All I need to do is a basic data dump, from a form. I've got a search form in my app that users can use to search through the records of the db. Once they find the recordset that they want, I want them to be able to click an Export button and dump the data to and excel spreadsheet.
On the search form, there are multiple fields for filtering the query, and once the query is complete, the recordset is displayed in a Listbox, that can be used to view the records before exporting. This all works well. I just don't know how to get my data to export to an excel file.
Thanks.
devRyan
I was wondering if someone could tell me how to export data to excel. I've looked in the FAQ and can't seem to find anything there on the topic.
All I need to do is a basic data dump, from a form. I've got a search form in my app that users can use to search through the records of the db. Once they find the recordset that they want, I want them to be able to click an Export button and dump the data to and excel spreadsheet.
On the search form, there are multiple fields for filtering the query, and once the query is complete, the recordset is displayed in a Listbox, that can be used to view the records before exporting. This all works well. I just don't know how to get my data to export to an excel file.
Thanks.
devRyan