I'm trying to add multiple records into an Access. I can get one record to add using the INSERT function, but I'm trying to add multiple records without using another table. Any help out there? For example this would be a possible input string. All fields have data in the values:

INSERT INTO Employees VALUES ('456342345', 'Cobb, Frank', '452 2nd ST, Newtown, AR 12456', '1235432359', 'h123@jcom.net', '5678', '100299', '35100')/
INSERT INTO Employees VALUES ('457456789', 'Sands, Jeff', '545 10th ST, Newtown, AR 12456', '1235423456', 'g123@jcom.net', '5678', '110299', '35200')/

Not sure if this will work but replace your /'s with a ; that might work...

In sql you can put go between the lines and that will work....

Other then that the only way I know of would be by executing multiple insert statments

I tried that, if you place the ; after the first record you get an SQL error that there are characters after the ;

Just run a loop and execute 1 sql statement on each step of the loop.