+ 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,510
    Thank Post
    1,319
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199

    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
    10,984
    Thank Post
    850
    Thanked 2,650 Times in 2,250 Posts
    Blog Entries
    9
    Rep Power
    763
    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,510
    Thank Post
    1,319
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    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
  •