problem while import TXT file

[koolprasad2003]

Hi all i have sql 2005 installed on my m/c. i want to import txt file which just exported from SQL 2000. i am using Import/Export wizard but problem is while importing it will automatically change column size and it's datatype. means it varchar to nVarchar size 20 to 2000 then i have to go in advanced import option and correct datatype and size for all columns why this happens ??? where i am wrong ??? is there any setting ??? thanks in advance koolprasad2003

Rating always..... WELCOME Be a good listener...Because Opprtunity knoughts softly...N-Joy

[_Damian S_]

Create the table first with the correct sizes, then import the text file into your table.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

[koolprasad2003]

thanks for reply damian i have done same thing as u told above but still i have to go in advanced import option and correct datatype and size for all columns. how do u import your txt files ??? or is there any option for the same ??? thanks in advnace koolprasad2003 :)

Rating always..... WELCOME Be a good listener...Because Opprtunity knoughts softly...N-Joy