Vbscript to export query results from MS Access

[RabbieBurns]

I have a crosstab query in a MS Access database that I want to export to excel.

 

Ive got a vbs to print reports from the database, I was just wondering if there was any way of scripting the exporting the results of a query from a vbs?

[SYNACK]

You could run the query on the database and chuck the results into excel easy enough:

 

Connect to the database, run the query and read out your data into a VBS controlled Excel window:

 

Grab the information:

How To Call a Parameterized Query to an Access Database with ADO

 

Output to excel:

Automate Excel In Vbscript

[RabbieBurns]

cheers for the reply. I will check out the links, but I know 0 vbscript so will probably be back soon for some help