Output to Excel File

  • Thread starter Thread starter seo-highrankings.com
  • Start date Start date
S

seo-highrankings.com

Hi all,

I need to have the results of an MS Access 2002 query produce a Microsoft
Excel Spreadsheet.

Is there a way to do that from inside Access without having to purchase a
separate Active X app?

Thanks!

--

James Taylor

http://www.aicompany.com - Search Engine Optimization Services
http://www.seo-highrankings.com - Free SEO Tools!
 
Create a query which represents the way you would like to
see the data in Excel. Use docmd.sendobject in VB to
autmatically save the this query in Excel.

You could create a Button on a Form which automatically
runs the docmd.sendobject command for you in VB. Your
help file will tell you about the docmd.sendobject
settings. Your third argument should be acFormatXLS.

Good luck.

Kevin
 
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

Change the color of the label on a Y/N form element basedupon value 2
Output Query to Excel 1
Output Query as an Excel file 2
Best method / software for graphical output from dynamic excel data 0
Output Access Query to Excel Spreadsheeet 4
Microsoft Works to Microsoft Office 6
Output to : Template file 3
Access query output to MS Excel template 2

Back
Top