export data from access to excel

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

hi all,
i want to "manage" access from excel,put data in a file,calculate and
ctr,
the data will come with a recordset but what is the fastest way to
export to excel.
please give me examples if you have
 
Hi - I'm not exactly sure what you mean by 'manage' access from excell, but
the fastest way to export to excell is to run your Query, then with the data
on screen go to the File Menu, then to Export. Alter the Save As type to
Excell, then hit Export All.
However, if this is something you need to do more than once and it is the
same Table/Query, then a quick and easy way is to create a quick one line
Macro using the OutputTo action, then attach the Macro to a Button,
Keystroke, etc.
Hope this was what you were asking --- yours Dika
 
You must log in or register to reply here.

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

Rounding difference in Access 2003 text exports 2
Exporting Data from access and appending to an existing excel sprd 3
Access #Error & Excel Pivot 0
How to Export Gmail Emails to PST Format? 5
Export to Excel - combine multiple fields in one cell 1
export to excel and save 4
Remove borders when ms access 2007 performs an export to excel? 4
Export to Excel 3

Back
Top