Hi 
In MS Access How can we insert multiple records into database using asp. 
INSERT INTO table (name,lastname,address) values
       ('A','B','C'),('D','E','F'),('G','H','I');

Thanks 
Balen.

One Insert statement enclosed within a loop

-----Original Message-----
From: Balen K. [mailto:kbalen@y...]
Sent: Saturday, March 08, 2003 6:35 AM
To: ASP Databases
Subject: [asp_databases] Inserting multiple records


Hi
In MS Access How can we insert multiple records into database using asp.

INSERT INTO table (name,lastname,address) values
       ('A','B','C'),('D','E','F'),('G','H','I');

Thanks
Balen.