Export data from tables to Excel

[Andysc]

Hi
I want help on exporting data from tables to Excel.
Im using a form with a command button when button is pressed i want all the
data on the form to goto an Excel spreadsheet but i want the spreadsheet to
auto save with the primary key as the file name.

Thank you
Andy

 

[Jeanette Cunningham]

Andy,
you can use a macro with transfer spreadsheet.
In the macro you specify the name for the new file.
It is auto saved.

Jeanette Cunningham

 

[Andysc via AccessMonster.com]

Thanks Jeanette
Will try this and get back to you if i need more help

Andy,
you can use a macro with transfer spreadsheet.
In the macro you specify the name for the new file.
It is auto saved.

Jeanette Cunningham

Hi
I want help on exporting data from tables to Excel.

[quoted text clipped - 6 lines]

Thank you
Andy