Scripts Thread, Vbscript to export query results from MS Access in Coding and Web Development; I have a crosstab query in a MS Access database that I want to export to excel.
Ive got a ...
20th June 2008, 03:49 PM #1
Vbscript to export query results from MS Access
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?
20th June 2008, 04:06 PM #2
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
Thanks to SYNACK from:
RabbieBurns (24th June 2008)
24th June 2008, 11:09 AM #3
cheers for the reply. I will check out the links, but I know 0 vbscript so will probably be back soon for some help
Last Post: 24th July 2009, 10:49 PM
Last Post: 22nd May 2008, 04:36 PM
By SYSMAN_MK in forum Web Development
Last Post: 15th April 2008, 09:37 PM
By Simcfc73 in forum Network and Classroom Management
Last Post: 23rd October 2007, 01:37 PM
By Nij.UK in forum Windows Vista
Last Post: 6th June 2007, 10:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)