I would like to create an excel where users will be entering data and click on "Load"(for example).
Here is what i will do:
-> Read the data from Excel
-> Call Sybase SQLServer Stored procedure for each row passing the cell values as arguments.
I know there is something like ListObject but that is like an Array and we will have to double_loop it to get the row and column values.
do we have any other option like we have DataTable/DataSet in .Net?
Examples would be better