Convert SQL table to Excel in VB.

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Convert SQL table to Excel in VB.

Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 12th, 2004, 03:48 AM

anita

anita is offline

Authorized User

Join Date: Nov 2003

Posts: 10

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Convert SQL table to Excel in VB.

What is the sample VB code to convert SQL table to Excel.

I have a SQL table which has varying number of coulmns
decided at run time. I want to export the table to excel
as a report.

Can anybody suggest a method.

Regards,
Anita

Old

May 13th, 2004, 04:58 PM

Greg Griffiths Greg Griffiths is offline

Greg Griffiths is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 344

Thanks: 0

Thanked 1 Time in 1 Post

Default

check out http://www.greggriffiths.org/webdev/both/excel/ which contains some samples for ASP as well as some links which may assist.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert a SQL Statement from MS Access to a SQL	Corey	Access	6	March 28th, 2007 12:33 PM
Convert Excel to PDF	shivavalkyre	Beginning VB 6	1	March 15th, 2007 03:44 PM
Convert data from Excel to SQL	jerry_Chihuas	Java Espanol	2	November 18th, 2006 05:46 PM
convert dsr file from vb to vb.net	Shashi001	VB Components	1	September 22nd, 2006 12:24 PM