SQL & Access

M

McWit

How do I enter multiple row data through an Access Query in SQL view?
After the first INSERT "table" VALUES entry I get an error message. I can
enter one line at a time and run the query, but if I attempt multiple lines I
get the error message.
 
J

John Spencer (MVP)

It depends. What is the source of the data you are tring to INSERT into the
table. If it is a query then you can use the alternate syntax. For example,

INSERT INTO SomeTable (FieldA, FieldB)
SELECT FieldX, FieldY
FROM SomeOtherTable
WHERE FieldOne = "XXX"
 
Top