Adding multiple records to a db at the same time?

[redsand]

What is the best way to add multiple records to an access db from asp.

What I have done is set up a data entry asp page, and on submit it saves the record to a database. Users would like it set up in Excel(Grid) format so they can enter multiple records at once then click submit once. Do I need an active x component to do this? I am new to asp and would appreciate your expert opinions.

 

[Tarwn]

I have a similar object where people paste information into a page from excel and when it submits to the next page I just loop through the data submitting one set at a time to the database until they are all in.
-Tarwn "Customer Support is an art not a service" - marketing saying
"So are most other forms of torture" - programmers response
(The Wiz Biz - Rick Cook)