Question What's the best way to automate the exporting of query results?

[paulcrigh]

Hi All,

I have created multiple queries which is now pulling the data I want.

My question is a simple one - Is there a better way of automating the execution of the queries and exporting the results to CSV files other than wrapping the queries up in a macro, exporting them to text files and automating the macro to run daily via a simple Windows Sheduled Task?

If so can you point me in the right direction or posts as I would be interested to hear other methods / learn and implement them

Many Thanks

Paulcrigh

 

[The_Doc_Man]

First question is, what would you RATHER see?

One possibility is that if you wanted to open a "real" spreadsheet, you could open an Application Object for Excel, create a workbook, and use VBA code to do what you wanted. You can use a RunCode action in a Macro, so the Windows Scheduler part wouldn't go away but the "export to .CSV file" part could be different.

If the utility in question supports VBA automation then you can use it to do such things. If the utility you really WANTED to use doesn't support the COM (automation, ActiveX, .. etc) methods, then life gets much harder.

Tell us what you would REALLY want to see and maybe one of us can offer some pointers. If the EXCEL part sounds good, search this forum of Application Objects and look in the Modules and VBA section for articles on such types of activation.