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 into TABLE.

E.G.

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

For some reason this won't work. Anyone know why I might be getting this error. Your help is really appreciated!!! TIA!

 

[hennep]

I have tried your insert statement and it works on MS-Access 97 SR2
The reason for failure could be SR1, it had several problems with queries.

 

[MichaelRed]

Possible typo?

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

Needs a space after the "(FirstName,".

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




MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over