Adding mulitple rows in a table...

[KVisions]

I have hopefully a simple question. How do you insert multiple rows into a table at one time in access? So far i only been able to insert one new row at a time. i dont know if i need to use and append or update query or even where to begin. Can someone please help me out?

 

[lespaul]

If you have a list of values that you are trying to enter, then you have to do it one at a time:

INSERT INTO SomeTable (Field1, Field2, Field3) VALUES ("Text1", Number1, "Text2")

If the information is coming from another table, then you can insert multiple rows using a query to get the data:

INSERT INTO SomeTable (Field1, Field2, Field3) (SELECT Field1, Field2, Field3 FROM SomeOTHERTable)

If you have an external file that contains the information, you can import it.

HTH



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[KVisions]

so what kind of query would insert multiple rows at one time?

 

[PHV]

From where are supposed to come the new rows ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886