Export to Excel

[Danny]

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,
DD

 

[theprez]

You can use the OutPutTo command for the table. It can be exported to different formats, including Excel.

 

[Danny]

export to excel

Thank you very much, it is working!

DD