Issue with Loading Excel in Text Format

• SQL_By_Chance

  Hall of Fame

  Points: 3915

  More actions

  October 3, 2011 at 2:25 am

  #258165

  Hi,

  I encountered a problem with Datatype conversion in Excel.

  Text field : 40735Date Type : 7/11/2011

  I uploaded the column with Text Format and want to convert into a date format now.

  Does anyone know How can I convert the text field in Data format without uploading the file again ?

  Regards,

  Ankit

  ______________________________________________________________________

  Ankit
  MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
  "Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
  You are already naked. There is no reason not to follow your heart.”

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 3, 2011 at 3:20 am

  #1389367

  You can convert the string to a date using the CONVERT function and providing an appropriate date style.

  See here for more info: http://msdn.microsoft.com/en-us/library/ms187928.aspx?ppud=4

  -- Gianluca Sartori