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