Hi

Can any one help me how to insert the data from a form to multiple rows in the access database.

For example: In a form if i have 14 fields, one the submit button is clicked 7 rows should be go into a row of the table and the remaining 7 should go to same table into a different row. The table has only 7 columns.

Thanks
Ram

You want to show and insert 2 rows worth of data at once?

What a strange app!

Read the Dw2 link in my signature, section "Creating a Simple Data App"
After you do this you'll have knowledg eof something called a TableAdapter. Just call its Insert twice:

tableadapter.Insert(textbox1.Text, textbox2.Text ....)
tableadapter.Insert(textbox8.Text, textbox9.Text ....)

__________________

DW1: Data Walkthroughs 1.1...DW2: Data Walkthroughs 2.0...DDS: The DataSet Designer Surface...ANO: ADO.NET2 Orientation...DAN: Deeper ADO.NET...DNU...PQ