Results 1 to 5 of 5

Thread: import issue

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: import issue

    I am importing an excel file into the DB and one of the column in the excel sheet has the data shown below.

    1111
    2222
    nnnnn
    llll
    3kkk
    4fff
    yyyy
    xxxx

    WHen i import this data i could not get the data nnnnn,llll,yyyy,xxxx into my db.

    And after few attemts i found that if i have the first element in the list start with an alphabet its importing all the information start with alphabets(nnnnn,llll,yyyy,xxxx).
    If the first element in the list start with a numeric value its only importing the following values(1111,2222,3kkk,4fff).
    But how can i import all the records into my DB.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What are you using to perform the import? DTS?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    yes i am using DTS.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    DAMN...another reason to not use DTS...

    I Just went through that with someone else....it loads them as null, right?

    I'd say bcp

    What the layout of the file?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The simplest answer is to export to a text file, then import that text file using DTS. See KB#236605 for more explanation. The problem lies in how DTS attempts to process mixed rows (some text, some numeric cells), where if you convert everyting to text it becomes a non-issue!

    -PatP

Posting Permissions

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