+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    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?

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,239
    Thank Post
    882
    Thanked 2,742 Times in 2,316 Posts
    Blog Entries
    11
    Rep Power
    784
    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

  3. Thanks to SYNACK from:

    RabbieBurns (24th June 2008)

  4. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,531
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    cheers for the reply. I will check out the links, but I know 0 vbscript so will probably be back soon for some help

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 16
    Last Post: 24th July 2009, 10:49 PM
  2. IIS 6 Access control
    By Ryan in forum Windows
    Replies: 14
    Last Post: 22nd May 2008, 04:36 PM
  3. Access Control Of Website
    By SYSMAN_MK in forum Web Development
    Replies: 5
    Last Post: 15th April 2008, 09:37 PM
  4. Network Access Control Solutions
    By Simcfc73 in forum Network and Classroom Management
    Replies: 5
    Last Post: 23rd October 2007, 01:37 PM
  5. Vista UAC - User Access Control
    By Nij.UK in forum Windows Vista
    Replies: 17
    Last Post: 6th June 2007, 10:19 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •