copy & paste excel into asp.net

[hamking01]

Is it possible to copy and paste excel data into a asp.net page and insert each row into the database. With Access, users could copy data in excel and paste into Access with all the records being inputted at once. Is this possible with ASP.net

 

[hamking01]

I've gotten it to work where I can see the excel file as a datagrid in the html. But right now, it will only work with Datagrid's AutogenerateColumns="true". If I set it to false, the boundcolumns don't work. Don't think it's recognizing the first row of the excel as headers. With my current method is possible to select the excel columns to display in datagrid boundcolumn, or does it have to be AutogenerateColumns.

I was thinking that if it was possible then I could add a checkbox in the first column. Users could then add the selected rows to Access.