bcp a file having five columns and subcolumns (not fixed in each row) in its first column in a table .

  • Malaysian Ringgit MYR 3.3430 3.3480 3.34550

    Maldives Rufiyaa MVR 12.7500 12.8500 12.80000

    Mongolian Tugrik MNT 1175.5000 1177.8000 1176.65000

    Nepalese Rupee NPR 62.8960 62.9120 62.90400

    New Zealand Dollar NZD 0.7607 0.7612 0.76095

  • Unless the "spaces" between the columns are something besides spaces, then you can't use BCP to import this file because the country names may also have spaces.

    --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 1 (of 1 total)

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