Results 1 to 1 of 1

Querying SQL database and putting results in specific columns of excel

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2008
    Posts
    1

    Querying SQL database and putting results in specific columns of excel

    Hi all,

    I am pretty new to programming. So need your help. I need to query the SQL database and put that in excel. The complex part is each row is different query and each query should use the particular column name and date range to fill the cell. I have attached the excel file. The column headers B1 (City names) and B2 (DateRange) are hardcoded. Also A3, A4 are hard coded too. Now I need to query for the 3rd row and fill the cells (B3, C3, D3..until the last column). Then go to the next query for the 4th row and get the results until the last row.. How would I do it? Can someone walk me step by step. I appreciate all your help..

    Thanks,
    invent1
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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