Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBA access recordset export to excel
- Thread starter dazbc
- Start date
You may wish to review Access VBA help for the TransferSpreadsheet Method and OutputTo Method, both of which let you export named queries to Excel.
It may be appropriate to save queries and use one of these methods to export the queries rather than trying to export recordsets.
It may be appropriate to save queries and use one of these methods to export the queries rather than trying to export recordsets.
- Thread starter
- #3
well currently i have comboboxes which give selections and the recordset fills the next combobox from the previous combobox - comboboxes (month, year, department and employee) and when a button is clicked it fills a textbox with the total vat (for a mobile phone billing system) but what i want to do is when i click the button, instead, i want the values selected from the comboboxes to be exported into excel... is it possible??
- Status
Similar threads
- Locked
- Question
- Locked
- Question