Export data from tables to Excel

  • Thread starter Thread starter Andysc
  • Start date Start date
A

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
 
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
 
Thanks Jeanette
Will try this and get back to you if i need more help


Jeanette said:
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.
Click to expand...
[quoted text clipped - 6 lines]
Thank you
Andy
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export data from text box to Excel 0
Filter Query - export spreadshet 1
Button to Export Data to Excel? 9
Export and email table 4
export to excel from filtered datasheet 2
Export Data from an access table to a pre-formatted excel template 1

Back
Top