Results 1 to 2 of 2
  1. #1
    learning_graccess is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    40

    insert multiple rows in access

    Hi,
    I created a table with field names "id", "name", "score". Now I want to insert values for this table. I don't know how to do insert multiple rows into this table but I can do single as below.

    insert into table
    values (1,'XYZ',55)



    I tried the below but it doesn't work
    insert into table
    values (1,'XYZ',55),
    values (2,'xaz',73)

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    A values clause can only insert a single record. If the values are coming from a table, a select clause can insert multiple records:

    INSERT INTO...
    SELECT...
    FROM...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Insert multiple records button
    By Aragan in forum Forms
    Replies: 6
    Last Post: 01-03-2012, 10:57 AM
  2. Insert x number of rows based on value
    By opopanax666 in forum Programming
    Replies: 4
    Last Post: 10-26-2010, 03:26 AM
  3. INSERT INTO and UPDATE to multiple tables
    By lupis in forum Import/Export Data
    Replies: 6
    Last Post: 05-19-2010, 05:21 AM
  4. Replies: 5
    Last Post: 12-10-2009, 10:33 PM
  5. Access to Excel transferring multiple rows to single row
    By peter_lawton in forum Import/Export Data
    Replies: 10
    Last Post: 09-23-2009, 10:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums