Inserting into a Table in Access with more the one record at a time

[russeldraper]

Hello,

I've been interting into a table with a series of the following statement in a for loop.
INSERT INTO Tester VALUES (Male, 60,1);

I was wondering if I could isert into a table with more than one record at a time, maybe with a multi-dimensional array, or even what the syntax for that SQL statement would be to insert two records at a time. The program is taking way to long with the SQL insert statements I have now embeded in a for loop.

Thanks for the help

 

[KenReay]

Hi

If you had the values you want to insert in another table you can do an

INSERT INTO .... SELCT FROM .... type statement, see Access help for details and example


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[KenReay]

Hi

If you had the values you want to insert in another table you can do an

INSERT INTO .... SELECT FROM .... type statement, see Access help for details and example


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK