Insert into statement errors

[iXPhound]

Hi all! When I attempt to use the Insert into statement I get an Expected: end of statement error and it highlights the insert to TABLE name.

E.G.

INSERT INTO Employees (FirstName, LastName, Title) VALUES ('Harry', 'Washington', 'Trainee');

I have upgraded to Access SR-2 with no success. Is there sometime of reference that I have to turn on, or a specific order it has to be in?

Anyone know why I might be getting this error. Your help is really appreciated!!! TIA!

 

[jimmythegeek]

Try this:

INSERT INTO Employees (FirstName, LastName, Title) SELECT ('Harry', 'Washington', 'Trainee'); Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[iXPhound]

Same error...Expected: End of Statement. Any other suggestions? I really appreciate the help.

 

[jimmythegeek]

Where are you doing this at? In a query or in code? Jim Lunde
compugeeks@hotmail.com
Custom Application Development