Export to Excel

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I need to create a button on a main form to export a select query to an
Excel spreadsheet. What will happen is when user click on this button, it
will open the dialog window asking the user for the location to save the
Excel file and the Excel file name. Upon completed this information Access
will create the Excel file to that location. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
How to Convert EML to PST in 2025? 0
Exporting from Access 2000 to Excel via script 2
Export data from tables to Excel 2
Excell 2021 0
Select drive to export file to 1
setting the export location through code or macro 2
export to excel from filtered datasheet 2

Back
Top