SQL & Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
Back
Top