+ Reply to Thread
Results 1 to 2 of 2

Run multiple queries using excel macros and return the output in excel format

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Run multiple queries using excel macros and return the output in excel format

    Hi,

    I have a requirement of running mutiple sql queries for pulling the data and export the data into different sheets of excel. i.e Output of every query has to be placed in different sheets of 1 workbook.

    I have made the connection to the database, and I am able to successfully run 1 query and retrieve the output in one of the sheets of excel.

    Can anyone help me to run multiple queries at the same time and export the data in workbook sheets.

    Many Thanks in advance,

  2. #2
    Registered User
    Join Date
    01-03-2014
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Run multiple queries using excel macros and return the output in excel format

    It would be of great help, if you could help me to resolve this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Output Text file is empty while exporting from excel table using macros
    By arry0207 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2013, 08:08 AM
  2. Importing images to Excel and macros/web queries?
    By jsartrean in forum Excel General
    Replies: 0
    Last Post: 02-07-2007, 04:04 PM
  3. Importing multiple XML queries into Excel
    By Dave Bailey in forum Excel General
    Replies: 0
    Last Post: 10-07-2005, 05:05 AM
  4. [SOLVED] HOW DO I TRANSFER EXCEL SPREADSHEETS WITH QUERIES AND MACROS?
    By Peachtree Help in forum Excel General
    Replies: 1
    Last Post: 03-20-2005, 03:07 AM
  5. [SOLVED] multiple queries in Excel
    By RickT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1