By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

button to export table into excel

P: 17

I am a newbie here for exporting about exporting things into excel.
I have a form displaying information that user can add/update which is stored into a table.
What I want is a button on the form that user can export all info into excel that table only.

thank you
Jan 9 '08 #1
Share this Question
Share on Google+
1 Reply

P: 45
Add a button. At the event on_click add

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, tablename, newfilename
Jan 10 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.