none
How to import data from excel column with over 255 characters?

    Question

  • Hi,

    I'm having dificulties in loading data into a table coming from an excel file because one of the columns is a text based with an average of 1024 characters... How can i import that column? The excel source always shows me the column as a DT_WSTR of 255 characters...

     

    Best Regards,

    Luis Simões

    Wednesday, June 21, 2006 12:24 PM

Answers

  • Just search your registry for TypeGuessRows and change its value from 8 to 0.

    This will allow all sheet to be used for data type guessing.


    Smile

     

    Regards

     

    Monday, December 10, 2007 10:48 PM

All replies

Monday, December 10, 2007 10:44 PM
  • Just search your registry for TypeGuessRows and change its value from 8 to 0.

    This will allow all sheet to be used for data type guessing.


    Smile

     

    Regards

     

    Monday, December 10, 2007 10:48 PM
  • From KB

    NOTE: For performance reasons, setting the TypeGuessRows value to zero (0) is not recommended if your Excel table is very large. When this value is set to zero, Microsoft Excel will scan all records in your table to determine the type of data in each column.

     

    Monday, December 10, 2007 10:58 PM