Help with insert query please

[viresh1981]

I used this sql in oracle and it worked:

insert into room values ('00012','1A','B','120','00002','Sports
Hall','N','0');
insert into room values ('00013','1B','B','20','00002','Changing
Rooms','N','0');
insert into room values ('00014','2','B','38','00002','Class
Room','N','0');
insert into room values
('00015','3A','B','6','00002','Office','Y','6');
insert into room values
('00016','3B','B','2','00002','Office','Y','2');
insert into room values ('00017','4','B','33','00002','Class
Room','Y','25');

Am not at uni no more and only have ms access

i want to create the tables in access

i have hundreds of records but when i use the

insert into room values ('00012','1A','B','120','00002','Sports

Hall','N','0');
insert into room values ('00013','1B','B','20','00002','Changing

Rooms','N','0');
insert into room values ('00014','2','B','38','00002','Class

Room','N','0');
insert into room values

('00015','3A','B','6','00002','Office','Y','6');
insert into room values

('00016','3B','B','2','00002','Office','Y','2');
insert into room values ('00017','4','B','33','00002','Class

Room','Y','25');


it does not work, only with one record at a time
like this

insert into room values ('00012','1A','B','120','00002','Sports
Hall','N','0');



can anyone help so i can populate the table in one go - please somebody answer...............