1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

How do I insert multiple new records from a web form field into an MS Access database?

Discussion in 'SQL - Questions and Answers' started by Sean, May 25, 2006.

  1. Sean Guest

    Dialect: SQL 92
    The way I have things setup right now I can only insert one new record at a time to the database when I would like to be able to input 10 records or so at a time before I add each one.
    Sean, May 25, 2006
    #1

  2. irfanhab New Member

    Dialect: SQL 92
    You could make use of SQL scripts, something like:

    Code:
    insert into tablename values(....);
insert into tablename values(....);
insert into tablename values(....);
insert into tablename values(....);
and so on
    irfanhab, May 26, 2006
    #2

Share This Page