Results 1 to 4 of 4

Thread: Bulk Insert/Update Suggestions....

  1. Jul 18th, 2005, 03:18 PM #1
    jpiller
    jpiller is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    Cleveland, Ohio
    Posts
    185

    Bulk Insert/Update Suggestions....

    Hello All,

    I'm working on developing a web based application that will allow the bulk updating of a SQL Server 2000 database. The updates will vary in size from 8 records to upwards of 8000 records, and they will be in Excel file format. I am wondering if anyone has any suggestions or links that they could provide to help me develop a Stored Procedure on the SQL Server to allow for this to happen. I have been trying Google, but perhaps I'm just not typing the correct search string!!!

    Anyway, if anyone could provide thoughts/suggestions, I'm all ears!

    Thanks,

    Jim P.
    "The Force will be with you, always."

    --Ben Kenobi--
    Reply With Quote Reply With Quote
  2. Jul 21st, 2005, 12:18 AM #2
    pranoy
    pranoy is offline
    Addicted Member
    Join Date
    Jun 2005
    Posts
    139

    Re: Bulk Insert/Update Suggestions....

    Use DTS. You can get a lot of info on dts on http://www.sqldts.com
    Reply With Quote Reply With Quote
  3. Jul 21st, 2005, 01:27 AM #3
    oceanebelle
    oceanebelle is offline
    Frenzied Member oceanebelle's Avatar
    Join Date
    Jun 2005
    Location
    my n00k.
    Posts
    1,064

    Re: Bulk Insert/Update Suggestions....

    yup... bulk insert.. SQL Server has

    but not bulk export.. but in sqldts they have a downloadable module for it. I think.
    Reply With Quote Reply With Quote
  4. Jul 25th, 2005, 02:36 AM #4
    nkad
    nkad is offline
    Fanatic Member
    Join Date
    Sep 2000
    Posts
    770

    Re: Bulk Insert/Update Suggestions....

    Or how about mutliple INSERT statements.. Not pretty, but it works.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width