2 Replies Latest reply on Apr 28, 2013 4:46 PM by Shawn Wallwork

    Excel 2010 number of columns limit?

    Shawn Wallwork

      Even though Excel 2010 allows for a worksheet size of 16,384 columns:

       

      Excel Columns.png

       

      It seems the MS Jet Engine is still limiting the columns we can connect to, to 255. Is this correct? Is there a new version of the Jet Engine we can download and use, which will read all the columns before doing an extract?

       

      Thanks,

       

      --Shawn