Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need for More than 256 Columns
Is there another utility, application, or program that can read in a file
larger than the Excel maximum? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need for More than 256 Columns
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, CABGx3 "John in Boston" wrote in message ... Is there another utility, application, or program that can read in a file larger than the Excel maximum? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need for More than 256 Columns
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need for More than 256 Columns
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: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=509131 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |