Results 1 to 2 of 2

Thread: Bulk Insert

  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Bulk Insert

    How can I insert bulk of data into a table., something equivalent to the BULK INSERT command supported by SQL Server.

  2. #2
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Re: Bulk Insert

    Hi Krish

    I am sure there is some definate syntax for Bulk Inserts but y dont u use this shortcut.

    Insert into <Table-Name>
    Values(&value1,&value2,&value3 --- and so on.)

    When U will run it for first time It will ask for all values.
    Once you are through with row 1 you can type / on SQL prompt to insert new row. Once u r through with all inserts COMMIT at the end.

Posting Permissions

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