Exporting Excel data into Sql - how to read first row
Can any one help me out!!
I have to export excel data into sql table using asp..
I tried hard, and finally got a solution.. thanks to the webdeveloper forum which helped me over this..
My problem comes here..
When i read the excel file, there should be a column heading in the first row followd by data..
if i remove the heading then the first line will be the data line and its not reading the first line..
How can i do this..
I want it to read the first line of data even though no heading is present..
Thanks in advance