Post reply

Bulk Insert with multiple files

  • November 13, 2003 at 10:17 am

    #81460

    I have a VB program I wrote that loads databases using the bulk insert. Currently, if the user has a data file broken down into multiple files, they have to sort them together before running my program. Is there a way to get bulk insert to load from multiple files in one bulk insert command?

  • November 13, 2003 at 3:32 pm

    #481982

    Bulk Insert will only import one file at a time. Can the user run your program for each file?

    Can you re-engineer your program to loop through the files importing them one at a time?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • November 13, 2003 at 3:36 pm

    #481983

    Thanks. That was the original plan (the loop) I was just looking for a quicker way

  • November 14, 2003 at 8:07 am

    #482057

    quiker will be to do something like

    copy /b *.txt AllFiles.txt

    and then do Bulk insert on AllFiles.txt

    I am assuming all files are using same structure of course!

    Edited by - noeld on 11/14/2003 08:07:12 AM


    * Noel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply