hi
i need the help that how can i insert the 40 records in table through one form. I have already get the 40 records through loop on that form. can you help me in this issue.

Put an INSERT statement into your loop and execute it. Every time you get a piece of data in your loop insert it into the database.

Are these 40 different pieces of data destined for 40 different columns or just one column.