SQL Server Performance

importing excel

Discussion in 'Getting Started' started by lara99, Nov 2, 2009.

  1. lara99 New Member

    hi all, i have a question its regarding dts.i am trying to import the excel file,the problem is in one particular column the data is left justifiedand right justified, with character data left justified and numeric data right justified.when i am importing using it dts designer it is only importing character data it is not importingnumeric data. is there a way to import the data from excel so that it imports both characterand numeric data.please throw ideaslara
  2. Madhivanan Moderator

    Does the column of the table of the numeric type?
  3. lara99 New Member

    no it of the type general
  4. Madhivanan Moderator

    [quote user="lara99"]no it of the type general[/quote]
    Make it numeric and try

Share This Page