Post reply

How to easliy import Table data from a file created with osql -o

  • January 11, 2008 at 5:20 pm

    #185520

    I need to import the data from the file output.txt into the same table on another machine and db.

    What's the easiest way I can do that? Note that I don't have network access to the machines so only command line tools will be useful.

    Also, is bcp better for this type of operation on the export end?

    Here is an example of output.txt

    strUser strGroup

    strPassword bAutomaticLogOff sLogoffTime

    strCreateUser CreateDate

    strChangeUser

    ChangeDate

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

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

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

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

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

    Aaron Supervisor

    A1sauce 1 20

    asd 2005-03-21 00:00:00.000

    NULL

    NULL

    Administrator Supervisor

    A1Sauce 1 10

    sd 2004-02-26 00:00:00.000

    nic

    2007-10-19 06:44:08.00

    Thanks!

  • January 11, 2008 at 7:51 pm

    #767368

    Would you please post the data in a code window so it doesn't wrap?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 2 (of 2 total)

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