close

Is there another utility, application, or program that can read in a file
larger than the Excel maximum?

One option I think I would explore would be to only import columns of
critical need to the task at hand......most import utilities allow you to
decide whether or not to import each column.......perhaps that would wean it
down below 256....

Vaya con Dios,
Chuck, CABGx3quot;John in Bostonquot; gt; wrote in message
...
gt; Is there another utility, application, or program that can read in a file
gt; larger than the Excel maximum?
If you are trying to import a text file then you have the option to
skip a column (or more) in the Data Import Wizard.

Hope this helps.

Pete
I've been told that you can change the default number of columns in
Excel via a VBA script, buut I don't know how to do this. Some of the
VBA experts here could perhaps address this?

You may want to consider a database program such as Access.--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=509131

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()