How do I create a button to export query results to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working for a non-profit org and I am updating a database with some
things they would like to be able to do. I was wondering if there is a way to
create a button that would run a query and then export the results to an
excel spreadsheet. I konw how to do it manually but the people that will be
using the database aren't the most computer literate people so I was hoping
that I could just make a button and everything would just run behind the
scenes. Would I have to write code for this or could I make a macro?
 
I am working for a non-profit org and I am updating a database with some
things they would like to be able to do. I was wondering if there is a way to
create a button that would run a query and then export the results to an
excel spreadsheet. I konw how to do it manually but the people that will be
using the database aren't the most computer literate people so I was hoping
that I could just make a button and everything would just run behind the
scenes. Would I have to write code for this or could I make a macro?
Click to expand...

Read VBA help on the TransferSpreadsheet method.
 
You must log in or register to reply here.

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

Exporting Access query to Excel file with passwords 6
Export query to Excel fails 6
Create Excel Lab test results 1
Exporting to Excel from Access 3
Exporting Query from Access 2007 to Excel 2007 4
Run 2nd query using results from 1st query 0
Export Access queries to excel 1
Export to Excel 3

Back
Top