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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to Excel

Status
Not open for further replies.

OCM

MIS
Sep 12, 2002
220
US
Greetings,

I’ve designed a database and deployed it without giving users access to the table. I’ve also created a report for them but, their reporting needs vary time-to-time and they want to be able to manipulate the table themselves; what columns they want to include and what columns not to include (hide, unhide, sort etc.).
I was thinking to create a button when clicked export the table in Excel format so that they can manipulate the table themselves in Excel.

Any idea would be greatly appreciated!

Thanks,

OCM
 
Connect the button to a macro with the TransferSpreadsheet action.

 
Thank, it is working now.

Ocm
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top