Hi,

I am a researcher and encountered a small problem, I will be grateful
if some one can help me to solve my problem.

I have some genetic data (character) in text file. There are 1600
columns of data and 2000 rows.

When I import data in to excel its taking only 256 columns. Using help
menu I realized it can only take maximum 256 columns. But, is there a
way I can import data in to different sheets (7), each sheet taking
252 columns, where first 2 columns are ID (keys).

In order to run analysis I need this data in excel format, it doesn't
matter even if it is in different sheets.

If any one wants to look at data, please let me know I can send a
sample of all columns and couple of rows.

Thanks and appreciate any help.

Prasad

excel 2007 has
1,048,576 rows
16,384 columns

you could upgrade............
:)
susan


On Mar 27, 9:49 am, wrote:
Hi,

I am a researcher and encountered a small problem, I will be grateful
if some one can help me to solve my problem.

I have some genetic data (character) in text file. There are 1600
columns of data and 2000 rows.

When I import data in to excel its taking only 256 columns. Using help
menu I realized it can only take maximum 256 columns. But, is there a
way I can import data in to different sheets (7), each sheet taking
252 columns, where first 2 columns are ID (keys).

In order to run analysis I need this data in excel format, it doesn't
matter even if it is in different sheets.

If any one wants to look at data, please let me know I can send a
sample of all columns and couple of rows.

Thanks and appreciate any help.

Prasad

sorry for being facetious....
:)

here's a link to a similar question in the newsgroup:
http://groups.google.com/group/micro...c3fe5e07adb787

and one mo
http://groups.google.com/group/micro...a457abf3438594

susan

On Mar 27, 10:31 am, "Susan" wrote:
excel 2007 has
1,048,576 rows
16,384 columns

you could upgrade............
:)
susan

On Mar 27, 9:49 am, wrote:



Hi,

I am a researcher and encountered a small problem, I will be grateful
if some one can help me to solve my problem.

I have some genetic data (character) in text file. There are 1600
columns of data and 2000 rows.

When I import data in to excel its taking only 256 columns. Using help
menu I realized it can only take maximum 256 columns. But, is there a
way I can import data in to different sheets (7), each sheet taking
252 columns, where first 2 columns are ID (keys).

In order to run analysis I need this data in excel format, it doesn't
matter even if it is in different sheets.

If any one wants to look at data, please let me know I can send a
sample of all columns and couple of rows.

Thanks and appreciate any help.

Prasad
- Hide quoted text -

- Show quoted text -

You should be able to find many alternatives through a Google search.
For example, when I searched on "excel import csv 256", these were two
alternative methods listed:

http://support.microsoft.com/kb/272729
http://apian.com/support/knowledgeba...?a=show&ID=384

On Mar 27, 6:49 am, wrote:

I am a researcher and encountered a small problem, I will be grateful
if some one can help me to solve my problem.

I have some genetic data (character) in text file. There are 1600
columns of data and 2000 rows.

When I import data in to excel its taking only 256 columns. Using help
menu I realized it can only take maximum 256 columns. But, is there a
way I can import data in to different sheets (7), each sheet taking
252 columns, where first 2 columns are ID (keys).

In order to run analysis I need this data in excel format, it doesn't
matter even if it is in different sheets.

You can adapt the code found he

http://support.microsoft.com/kb/272729/en-us
How to import data with more than 256 fields or columns into Excel

--
Regards,
Tom Ogilvy


" wrote:

Hi,

I am a researcher and encountered a small problem, I will be grateful
if some one can help me to solve my problem.

I have some genetic data (character) in text file. There are 1600
columns of data and 2000 rows.

When I import data in to excel its taking only 256 columns. Using help
menu I realized it can only take maximum 256 columns. But, is there a
way I can import data in to different sheets (7), each sheet taking
252 columns, where first 2 columns are ID (keys).

In order to run analysis I need this data in excel format, it doesn't
matter even if it is in different sheets.

If any one wants to look at data, please let me know I can send a
sample of all columns and couple of rows.

Thanks and appreciate any help.

Prasad