Prev: Help with sample query.
Next: problem with "#"
From: mario on 13 Apr 2010 14:53
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.
From: PieterLinden via AccessMonster.com on 13 Apr 2010 15:00
mario wrote:
>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.

It depends. Where's the data? Is it in a table or some kind of attachable
format? (delimited text file, Excel file...etc)?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

From: mario on 13 Apr 2010 16:09
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



"PieterLinden via AccessMonster.com" wrote:

> mario wrote:
> >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.
>
> It depends. Where's the data? Is it in a table or some kind of attachable
> format? (delimited text file, Excel file...etc)?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
>
> .
>
From: PieterLinden via AccessMonster.com on 13 Apr 2010 16:41
mario wrote:
>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

As far as I know, Access doesn't support that syntax. SQL Server 2008 does,
so you might be able to create pass through queries to do it, if you're
writing to SQL Server...

If you're just entering data through a form in Access, you don't need *any*
queries at all to do this. Just bind the form to the table and open the form
in data entry mode. You won't see existing entries, but it's the most
efficient way of doing what you want.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

 | 
Pages: 1
Prev: Help with sample query.
Next: problem with "#"