I have a requirement to pull data from Excel file into a datareader.
M
Am able to achieve it but in addition to that I want to have a additional column which has auto increment record no based on no. Of records present in the Excel.
I can't datatable for this scenario because am getting huge data from Excel file which can't be loaded into a datatable and push it into database.
So while I had used Row_Number() in the Ms access query while pulling data from the file but it didn't worked for me.
Please suggest a approach so that it can solve my issue.
Hi,
I have a requirement to pull data from Excel file into a datareader. M Am able to achieve it but in addition to that I want to have a additional column which has auto increment record no based on no. Of records present in the Excel.
I can't datatable for this scenario because am getting huge data from Excel file which can't be loaded into a datatable and push it into database.
So while I had used Row_Number() in the Ms access query while pulling data from the file but it didn't worked for me. Please suggest a approach so that it can solve my issue.