Programming Tutorials

Comment on Tutorial - Insert cell data in an Excel file using OLEDB in VB.net By Issac



Comment Added by : Hendrik Jabs

Comment Added at : 2009-12-10 02:46:13

Comment on Tutorial : Insert cell data in an Excel file using OLEDB in VB.net By Issac
Hi,
I've tried this but got a problem. First I run a 'create table'- command to define my columns and datatypes in the excel file.
Then I tried to insert a datatable to the excel file by running an 'insert'- command for each row of the datatable. The excel- sheet only contains the header and the last row of my datatable after that. It seems that the insert command starts to write always in the second row.
How can I solve that problem?
cu


View Tutorial