65536

[Steven Hook]

An Excel Spreadsheet takes 65536 rows, I need 1000000 rows, is there a way
of increasing the number of rows in a spreadsheet, or do I have to split it
up into several files.
The data is only about 7 colomns wide, but it is to be used for
persolnalisation for a printing press so I can't place the data in section
nexto eachother.
Thanks
Steven

 

[Frank Kabel]

Hi
you can't do this in Excel. 65536 is the max. AFAIK Quattro Pro has so
many rows but to be honest for this amount of data use a real database
and not a spreadsheet!!

 

[Nikos Yannacopoulos]

Steven,

The answer is absolutely NO in Excel, but sounds like something Access would
be happy to do for you.Have you considered it?

Nikos

 

[Steven Hook]

I would prefer Excell, because the rip software for the printing press that
will use the data likes Excell spreadsheets,
I'll have to check maybe it'll take CSV.

 

[Steven Hook]

I thought a Database would be a bit of an over-kill, it's just 9 colomns of
numbers to be printed for "scratch n win" type tickets, but if Excell can't
maybe I'll try a CSV file I think I might be able to write a script in linux
to generate the data, so CSV might be the answer
Thanks

 

[Frank Kabel]

Hi
still would go the database way. Should be faster than processing a
text file esp. if you need some reports out of it. And using Access for
example should be quite easy:
- setup the table
- import your data
- run some queries on it

You could also use Excel's pivot table function on this database table

 

[Myrna Larson]

If the data requires more than 65,000 rows, how can it possibly "like Excel
spreadsheets"?