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

Mar 5th, 2002, 07:46 AM

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

lenze · Mar 5th, 2002, 07:51 AM

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 ]

Mar 5th, 2002, 08:07 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 07:46 AM	#1
Guest Posts: n/a	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

Mar 5th, 2002, 07:51 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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 ]

Mar 5th, 2002, 08:07 AM	#3
Guest Posts: n/a	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.