Post reply

Import from excel file (cell with string too long is cut)

  • July 4, 2005 at 1:36 pm

    #86739

    I need to import a file excel into a database as a table.

    The process goes on until the end, all row are included, the only thing is that the cells (in the file xls) with string longer that....I don't remeber exactly how many character (may be 255)  are cut.

    In fact I remeber that excel doesn't export string longer more then a number of character (may be 255).

    Do you know how to change this value and export all character in a cell.

     

    Thank

  • July 6, 2005 at 9:59 am

    #571346

    I have got a similar problem. You have to change a registry entry because of the default bahavior of ADO which checks the first 8 rows of the excle file for guessing the width.

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel\TypeGuessRows = 0

    this is described here: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q257/8/19.asp&NoWebContent=1



    Bye
    Gabor

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply