Output to Excel File

[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!

 

[Kevin]

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

 

[seo-highrankings.com]

Thanks Kevin.

--

James Taylor

http://www.aicompany.com - Search Engine Optimization Services
http://www.seo-highrankings.com - Free SEO Tools!