insert multiple records from datagrid

[hamking01]

I have a datagrid where the data is from an excel sheet. I've added a checkbox column allowing users to select multiple rows. I want to have a button at the bottom of the page where it will insert the selected row's data into an Access database. I've looked into the "Insert...Select From..." sql, but i'm unsure how to use it with the "Select From..." reading from a datagrid.

I've posted this in both the ASP.net and Access Queries & JET SQL forums.

 

[BNPMike]

If you are using Access, import the excel data into a table, add the checkbox field to the table and display the datasheet. When users check a checkbox for a record, that will automatically update the record on the temporary table.

When they have finished and press the command button, you simply run an append query that selects from your temporary table to your target table where checkboxfield = true.