Insert Multiple Records into a Table

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.
 
M

mario

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Insert Into to insert multiple records 9
Insert Values Of External Table Into Current Data Table 0
Insert Into Queries 3
Two Tables Insert Into with Select @@ Identity 2
Insert multiple .dat files into one pdf without losing color of their graphs 0
Acces - insert multiple rows in a single sql-insert 8
insert query for unique records 1
Multiple values for Insert Into 5

Top