Error in generating DDL query

[Jack]

Hi,
I am creating a table and populating with data via two DDL queries.
The first DDL query I created is as follows:

CREATE TABLE TEST1
(ID COUNTER,
NAME TEXT(50),
STORAGESPACEASSIGNED TEXT(50)
)

The second DDL query I am trying to create is as follows:


INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("John Doe", "Kitchen Cabinet");

INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Jane Doe", "Apartment's Attic");

INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Sam Hugh", "Bedroom Cabinet");

INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Tom Jones", "Dining Room's Closet");

INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Erica James", "None");

However, when I am trying to run the second query I am getting the following
error:

Characters found at the end of sql statement and the second INSERT word of
the second insert statment is highlighted.

I have no idea why this is happening . I appreciate any help in advance.
Thanks.

 

[Allen Browne]

JET (the Access table/query engine), cannot handle multple INSERT statements
as a single query. You need to execute 5 query statements to adds the 5
records.

 

[Jack]

Thanks for the tip. I appreciate it. Best regards.