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?
Printable View
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?
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.
Thanx Rob i m trying it now and will tell u abt it
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.
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.
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?
Thanx Rob. I will start a new thread in VB6 forum and will post the code in that.
Hope to get the help there.