Export data from a tabe to excel sheet

**noshaba** · Oct 3rd, 2006, 11:56 PM

I need to develop an export module thru which data of a table will be moved to an excel sheet . Can any one help me in this regard? from where should i start?

**RobDog888** · Oct 4th, 2006, 12:42 AM

Use an OleDbConnection connection to a blank Excel workbook file. You can get the connectionstring from connectionstrings.com.
Then its just an Insert Into statement from your table to your Excel Sheet.

**noshaba** · Oct 4th, 2006, 01:23 AM

Thanx Rob i m trying it now and will tell u abt it

**RobDog888** · Oct 4th, 2006, 01:32 AM

You will need to create the blank excel file first manually and then embed it and when run, extract it in from your app for writting to.

**sanbatra** · Oct 4th, 2006, 01:36 AM

But will it allow to export more than 16K records.
I am doing similar operation in VB6 but it give me error message 3437: spreadsheet is full.
I am having approximately 50 K records which i need to save in excel.

**RobDog888** · Oct 4th, 2006, 01:43 AM

Excel can hold 65,535 records in a single sheet.

Maybe if you have a memo type field its taking up more then the average space?
do you have a thread in the VB 6 forum for it?

**sanbatra** · Oct 4th, 2006, 01:49 AM

Thanx Rob. I will start a new thread in VB6 forum and will post the code in that.
Hope to get the help there.

Thread: Export data from a tabe to excel sheet

Thread Tools

Display

Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Re: Export data from a tabe to excel sheet

Posting Permissions