To export the query data from sql sever to Excel Sheet using Vb - AndreaVB Visual Basic and VB.NET source code discussion board

AndreaVB Forum : VB General : To export the query data from sql sever to Excel Sheet using Vb

Poster

Message

sunil
Level: Trainee

Registered: 14-06-2010
Posts: 1

Ads by Lake Quincy Media

To export the query data from sql sever to Excel Sheet using Vb

Hi,
I'm doing a project in which i need to query certain data
from SQL Server and export it into the Excel sheet using the VB .
Thus the Excel can be printed by the VB commnads.

pls help me with your coding.

Awaiting the reply.

Thanks
___________
Sunil.
Sr.SWE, Wipro, India

14-06-2010 at 12:29 PM

stickleprojects
Level: Moderator

Registered: 09-09-2002
Posts: 1060

Re: To export the query data from sql sever to Excel Sheet using Vb

Hi
What have you tried?
a google for VBA EXCEL SQL came up with a few articles
Most notably, the general feature you are asking for is included in VB:
http://support.microsoft.com/kb/306125

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

23-08-2010 at 06:44 AM

AndreaVB Forum : VB General : To export the query data from sql sever to Excel Sheet using Vb


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2010 Andrea Tincani