| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to import a matrix of size 2057x2057
I cannot import a text file that has 2507 rows and 2507 columns. It gave me a
warning saying that the maximum size of matrix columns can be only 256. Is there a way to get around this? -- Kiran Programmer Analyst |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to import a matrix of size 2057x2057
There really is no great way around this. You are dealing with 2507 * 2507 =
6,285,049 records which is getting outside the realm of Excel. Even if you could get it imported, Excel would have some difficulty manipulating that much data... HTH "Kiran" wrote: I cannot import a text file that has 2507 rows and 2507 columns. It gave me a warning saying that the maximum size of matrix columns can be only 256. Is there a way to get around this? -- Kiran Programmer Analyst |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to import a matrix of size 2057x2057
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to import a matrix of size 2057x2057
Access only supports 256 columns as I understand it.
-- Regards, Tom Ogilvy "Franz" wrote in message ... "Kiran" ha scritto nel messaggio I cannot import a text file that has 2507 rows and 2507 columns. It gave me a warning saying that the maximum size of matrix columns can be only 256. Is there a way to get around this? Because of Excel limits (256 colums and 65536 rows), the only suggestion is: try using Access... :-) Hoping to be helpful :-) Regards -- Franz -------------------------------------------------------------------------- -------------- To reply translate from italian InVento (no capital letters) -------------------------------------------------------------------------- -------------- |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to import a matrix of size 2057x2057
"Tom Ogilvy" ha scritto nel messaggio
Access only supports 256 columns as I understand it. I was quite sure that Access had only limits in the dimension of file, but yes now I discovered also this one... :( -- Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to import a matrix of size 2057x2057
"Kiran" ha scritto nel messaggio
I cannot import a text file that has 2507 rows and 2507 columns. It gave me a warning saying that the maximum size of matrix columns can be only 256. Is there a way to get around this? Maybe you can try this http://support.microsoft.com/?kbid=272729 -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
| File Size Keeps Growing On Import | Excel Discussion (Misc queries) | |||
| i want to import all pictures into excel at the same size without. | Setting up and Configuration of Excel | |||
| Huge File size after import | Excel Programming | |||
| Huge File size after import | Excel Programming | |||
Hybrid Mode
