Data Import formatting issue

• tmacdonald

  SSC Veteran

  Points: 215

  More actions

  September 15, 2009 at 6:50 am

  #133951

  I'm pretty sure that there is an easy solution/fix for my issue. I have an application that imports data from a web page to an excel workbook and then it uses SSIS to import a data range into my SQL table. The issue that I am having is trying to figure out the proper importing format for one of my cells. It is supposed to come in as yy-mmm which makes me think that is should be a date or possibly a text format. When I import it into SQL, SQL sees it as dd-mm-yyyy. How do I correct my formatting?

  Or could I just import directly from the web page into SQL?

  Terry

• Matt Whitfield

  SSCrazy Eights

  Points: 8107

  More actions

  September 15, 2009 at 3:52 pm

  #1054153

  look at the help for CONVERT and see if you can provide a style code.

  Atlantis Interactive - SQL Server Tools
  My blog[/url]
  Why I wrote a sql query analyzer clone