Trouble with Excel Formating Numbers treated as text by Excel - Sample output attached

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 8, 2011 at 6:35 am

  #251769

  Hi SSIS Experts,

  I populate sever worksheets in a workbook from SQL Server.

  All of the numeric columns in excel have a green arrow in the top right hand corner.

  It interprets it as a text field and it gives you the option of clicking on each cell and convert to a number.

  I have attached Sample output.

  It list the following as action to be taken and I have done all of that and a lot more.

  I have CAST as a INT. Set the Data Types in the Data Conversion Task to a signed integer, formatted the Excel columns as numeric.

  I'm having no luck.:crying:

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 8, 2011 at 9:53 am

  #1418795

  Any ideas?:hehe:

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 8, 2011 at 3:35 pm

  #1419001

  I had the same problem with the phone & fax fields until I formatted them as (XXX) XXX-XXXX.

  Any ideas would be greatly appreciated.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  December 9, 2011 at 7:14 am

  #1419339

  Why is there an entire Excel manual in your post? I'm not really going to be bothered by reading it all...

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 9, 2011 at 7:25 am

  #1419356

  Koen Verbeeck (12/9/2011)

  ---

  Why is there an entire Excel manual in your post? I'm not really going to be bothered by reading it all...

  It is not exactly a manual but if you click to the right of a cell with an error it pops up the help text.

  I removed it.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/