Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2001
    Posts
    135

    Unanswered: Importing a TXT file to MSSQL

    hi, I have a TXT file with several fields with semicolom between fields.

    But after Importing is done, Decimal field Dont appears with
    comma.

    in other words , if I type in a DataBase using Enterprise Manager 123,45678 I get exactily 123,45678, but from
    Txt file I get 1234568.

    what do i missing?
    Tks
    Carlos Lages
    ps. Txt files is "12345678" even I put Txt file "123,45678"
    I get the same result in database

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Importing a TXT file to MSSQL

    In your table definition is the field a character field or numeric? What data type is it? This is just a thought, but maybe during the import job, DTS? is treating the field as some form of numeric field and ignoring the "," as that is not relevant..

    Hope this helps, or am i on the wrong track?

    Originally posted by Carlos lages
    hi, I have a TXT file with several fields with semicolom between fields.

    But after Importing is done, Decimal field Dont appears with
    comma.

    in other words , if I type in a DataBase using Enterprise Manager 123,45678 I get exactily 123,45678, but from
    Txt file I get 1234568.

    what do i missing?
    Tks
    Carlos Lages
    ps. Txt files is "12345678" even I put Txt file "123,45678"
    I get the same result in database

Posting Permissions

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