#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Philadephia
    Posts
    16
    Rep Power
    0

    Bulk Insert and FieldTerminator Problem


    Good afternoon,

    I am using a bulk insert to bring the contenets of a csv file into a temp table. The insert works but I found a new problem, some of the fields have a ',' in the middle of the field.

    My field terminator is ','

    Example
    "Joseph Abcde","Partner","Joseph.Abcde@xxxx.com","PasswordNotRequired, NormalAccount"

    "Joseph W. Wecfder, Jr.","Partner","Joseph.Wecfder@xxxx.com","NormalAccount"

    Notice the comma right after the last name and before the suffix on the 2nd record.

    Anythin I can do about that?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2004
    Posts
    83
    Rep Power
    10
    It's a pain, but you have to use a format file:

    http://technet.microsoft.com/en-us/library/ms178129.aspx

IMN logo majestic logo threadwatch logo seochat tools logo