05-05-2009
|
|
oOple Advertiser
|
|
Join Date: Dec 2007
Location: Kent
Posts: 548
|
|
Quote:
Originally Posted by c0sie
Can someone tell me what is wrong with the following code please?
Im trying to insert 3 rows of data into table STAFF in Access 2003 and keep getting an error saying "Charectors found at the of SQL statement"
INSERT INTO STAFF
VALUES ('C01', 'Steve', 'Zion', 'Worcester', 'WR25PF', 1, 'T01');
VALUES ('C02', 'John', 'Scarry', 'Worcester', 'WR25PF', 3, 'T01');
VALUES ('C03', 'Paul', 'Andrews', 'Worcester', 'WR25PF', 7, 'T01');
Any help will be greatly appreciated!!
|
Access doesn't like the semi colon character
|