Access VBA

a veyr good vba to do this, thank you

Button on access that will call the macro – which will grab the data from the access table and then spit it out on excel file, stored somewhere…

Have you looked at the help on:

Docmd.TransferSpreadsheet

Well you don't need any code for that.

You can simply import the table (or query) directly to Excel file and refresh the table whenever you need it.

VBA is also the option (let me know from where you want to run it Access or Excel).

Let me know what version of the Excel and Access do you have so I can assist you further.

Regards,

MSMax

Please see http://msdn.microsoft.com/en-us/library/office/aa164087(v=office.10).aspx

Hello MsMax

VBA is also the option (let me know from where you want to run it Access or Excel).
------- I would want to run the macro from within Access (preferably a form button)  - which opens up a specific excel file and  dumps the access table data

Let me know what version of the Excel and Access do you have so I can assist you further.
-----Excel 2010, Access 2010

thanks