Post reply

Export VarChar(6500) column

  • October 21, 2010 at 9:37 pm

    #1240699

    Hi Mahesh,

    You can try my method. When I encountered similar issue, I used the following steps to fix it.

    Step 1: Add "IMEX = 1 " ,

    Like this: OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 8.0;HDR=YES;IMEX=1; DATABASE = 'd:\WorkFolder', [TargetSheetName$] )

    Step 2: Modify the value in Windows Registry. Set TypeGuessRows from 8 to 0.

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel , TypeGuessRows = 8

    And then, Run your program.

    I hope that you will get your target:-)

  • October 22, 2010 at 5:31 am

    #1240824

    [font="Verdana"] thank you very much Larry.

    -- Mahesh[/font]

    MH-09-AM-8694

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

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