Cannot use INSERT INTO with access

[zlloyd1]

I am trying to insert values into a table of a database that I have created in MS Access 2010 using the INSERT statement, but it WILL NOT WORK!!
This is what I have tried most recently,


but it keeps telling me there is a syntax error that I cannot see anywhere??
If anyone can see what I am doing wrong with this please let me know, and thanks in advance!!

[orange]

Please show the fieldNames and datatypes for you table Employee.

You need a Values in your statement.

INsert into EMPLOYEE( field1...., fieldx) VALUES (firstfldvalue, second fldValue...)

see details at http://www.techonthenet.com/sql/insert.php

[pbaldy]

And in case it isn't clear, in Access you can only have a single INSERT statement in the query.

[zlloyd1]

Alright, but that is disheartening since my task is to add information to several different instances of the same fields. For instance, I need to add 7 different first names to the FName field, seven different last names to the LName field, seven different addresses to Address, etc.... I am supposed to do this using the INSERT statement in order to follow assignment parameters correctly.

[zlloyd1]

Here is the table Employee: Attachment 9041 I also need to add SQL code to create and insert a unique identifier to the Employee_ID and JTKey fields, but that is a different issue!!

[pbaldy]

I get an error on your attachment. You can do this to insert multiple lines if the data is in a table:

INSERT INTO...
SELECT...
FROM...