Exporting a Table into a blank Excel sheet

[biscuitboy]

Hi,

This in theory should be simple but for some reason I cant figure it out.

All I want to do is with a click on a button in Access I would like a blank excel worksheet to open and then a Table from Access called "Data" to be copied onto sheet1.

Can anyone help?

Best regards

 

[p27br]

use the transferspreadsheet method of the Docmd object to save your table to a spreadsheet, then
to open an instance of Excel you will have to use OLE/COM Automation

see thread692-90756