Insert Multiple Records into a Table

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

Can I insert multiple records into a table using "INSERT INTO"., it seems it
can insert only one record at one time.

INSERT INTO Table1 (F1, F2, F3, F4) VALUES ( 'CCP', 0.0115, 0.008202, 120)

Is there an alternate way to insert multiple records in MS Access Table
using a query.

Please help. Thanks.
 
The table I want to update is in MS Access and I'm trying to insert multiple
records into a table using a querry so I'm looking to write a querry like

INSERT INTO Table1 (F1, F2, F3, F4) VALUES ( 'CCP', 0.0115, 0.008202, 120),
( 'WCCP', 0.0125, 0.018202, 140)

Thanks
 
Back
Top