Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Import TXT file cannot work on SQL server 2005

    I have imported a TXT file every week on SQL 2000. Options,
    Fixed field
    File Type: ANSI
    Skip rows: 0
    Row delimited: {CR}{LF}
    Text qualifier: DoubleQuote{"} (default grayed out).

    It works fine. On SQL 2005, I cannot.

    If I keep same settings as SQL 2000, I cannot see file from Preview. If I change to Delimited, I can see file but there is only one column.

    Any suggestion?

    Thanks

    ZYT
    ZYT

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi, U txt have header?
    read this link: http://www.youlearnhow.com/how-to/im...rver_2005.aspx

Posting Permissions

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