How to export a table in access to excel via command button 2

[docmeizie]

How would you go about sending a table from Access to excel via a button on a form? I know it can be done but the process eludes me as of now. Any help would be greatly appreciated.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv

 

[batteam]

You would use the 'TransferSpreadsheet' function behind your form's command button. Access 'Help' files detail how this is used. I've used it myself many times and it does work very well. Only problem is that this function does not allow exporting a table into an existing spreadsheet - you must always provide your new file name and path. It will overwrite an existing one, however, if that's any consolation.

If you must get data from Access into Excel and it must be into an existing spreadsheet, you can use the Get External Data wizard in Excel. That works great too, once you get the hang of it.

Hope this helps. Good luck.

 

[gol4]

see output method

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]

DoCmd.OutputTo acOutputTable, "Employees", acFormatXLS, "Employee.xls", True