Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: SQL INSERT Statement in Access

    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')/

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    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

  3. #3
    Join Date
    Apr 2004
    Posts
    2

    INSERT function in Access with multiple records

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

  4. #4
    Join Date
    Apr 2004
    Posts
    50

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •