Automatic Access Query conversion to an Excel Spreadsheet

[JRA]

Help !!!
I'm trying to create some sort of macro or module that will automatically convert an Access query to an Excel spreadsheet by clicking on a button. Is it possible to do this? I was told that it should be able to be done by creating some sort of macro or module, but I can not seem to figure out how to do this. If anyone can help me I would really appreciate it.

Thanks,
James.

 

[JoeMiller]

Look up "Automate importing, exporting, or linking of data" in the help section to find out how to send queries to excel via macros or visual basic.

Joe Miller
joe.miller@flotech.net

 

[scking]

Run the query and press the 'Excel' button on the toolbar. If it is not currently there you will have to customize the toolbar. You can accomplish this quite easily by dropping the 'Excel' button on the toolbar.

Steve King Growth follows a healthy professional curiosity