Simple Question, How Do I send Data from a DB to Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Simple Question, How Do I send Data from a DB to Excel

  1. #1


    I just want to know, how to open a new worksheet in vb and then send specific data from a db to specific cels, rows in an excel worksheet. This has got to be really easy but I just can't figure it out. My DB is in SQL if that really matters but it should not.

    What I will do is create a query to get the specific date and then I just want to export that data to an excel worksheet.

    Any simple sample code or quick explaination will be great

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Helena, MT
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    Will not MS Query work? You can return data directly into your Excel sheet from a SQL database. You can set it to run on opening, manually, or whenever a specific cell value changes.

    [ This Message was edited by: lenze on 2002-03-05 06:53 ]

  3. #3


    MS Query wont really work, I get this info from any other program, and in that program i want them to send the info from this program to an excel worksheet, I don't want them to run Excel at all until they want to actually view the information sent to excel, the worksheet will be something like a printed document that can be edited.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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