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

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
>

"Kiran" <Kiran@discussions.microsoft.com>ha scritto nel messaggio
9CA9E307-6FCB-4779-A38A-428E821C358A@microsoft.com

> 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)
----------------------------------------------------------------------------------------

Access only supports 256 columns as I understand it.

--
Regards,
Tom Ogilvy

"Franz" <fra68ve@InVento.it> wrote in message
news:uzDkzmxSFHA.2128@TK2MSFTNGP15.phx.gbl...
> "Kiran" <Kiran@discussions.microsoft.com>ha scritto nel messaggio
> 9CA9E307-6FCB-4779-A38A-428E821C358A@microsoft.com
>
> > 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)
> --------------------------------------------------------------------------
--------------
>
>

"Tom Ogilvy" <twogilvy@msn.com>ha scritto nel messaggio
OeD$cB1SFHA.3552@TK2MSFTNGP10.phx.gbl

> 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)
----------------------------------------------------------------------------------------

"Kiran" <Kiran@discussions.microsoft.com>ha scritto nel messaggio
9CA9E307-6FCB-4779-A38A-428E821C358A@microsoft.com

> 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)
----------------------------------------------------------------------------------------