adios 717 Posted September 16, 2005 Share Posted September 16, 2005 (edited) Any of you bright sparks know a spreadsheet program that can handle 500,000 rows. OpenOffice and Excel both stop at 65,536. Been bugging me all day. I should specify, it needs to be windows based. I'm designing a system that will allow someone to download am updated list every month, alter it a little and upload. Basically excel with 7 times the row capacity would do it! Edited September 16, 2005 by DotBum Link to comment Share on other sites More sharing options...
Craig 6682 Posted September 16, 2005 Share Posted September 16, 2005 Only real solution is to create a database.... And anything this has more than 65,536 records really should be a database and not a spreadsheet. From the info you've given I'd knock it up in SQL Server but if you don't have that or you've never used it before, an Access DB will the job OK (although personally I can't stand MS Access!) Link to comment Share on other sites More sharing options...
peasepud 59 Posted September 16, 2005 Share Posted September 16, 2005 Only real solution is to create a database.... And anything this has more than 65,536 records really should be a database and not a spreadsheet. From the info you've given I'd knock it up in SQL Server but if you don't have that or you've never used it before, an Access DB will the job OK (although personally I can't stand MS Access!) 34296[/snapback] I love Access me! Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 16, 2005 Share Posted September 16, 2005 Jesus!!!!!!!!!!!!!!!!!! Link to comment Share on other sites More sharing options...
adios 717 Posted September 16, 2005 Author Share Posted September 16, 2005 I don't like to do anything real on a windows machine, this is all getting uploaded to a postgres db. I used EditPad in the end, one quick find and replace, it's easy enough to explain how to do that every month. Regular Expressions are your friend! Can't believe excel can't deal with half a million rows now. I'm sure it's been that way for 10 years. I know it's the exception to the rule but this is one case where that capacity would make sense. Thanks for the info. Link to comment Share on other sites More sharing options...
adios 717 Posted September 16, 2005 Author Share Posted September 16, 2005 Jesus!!!!!!!!!!!!!!!!!! 34335[/snapback] Not quite the usual excel request, Rob? Link to comment Share on other sites More sharing options...
Craig 6682 Posted September 16, 2005 Share Posted September 16, 2005 Only real solution is to create a database.... And anything this has more than 65,536 records really should be a database and not a spreadsheet. From the info you've given I'd knock it up in SQL Server but if you don't have that or you've never used it before, an Access DB will the job OK (although personally I can't stand MS Access!) 34296[/snapback] I love Access me! 34330[/snapback] What are you, a fecking hom?? Access smells of the rankest shit!!! Hate it with a passion, it's not a database, it's an application with a small, unstable database built in.... SQL Database is king! Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 18, 2005 Share Posted September 18, 2005 it would be if it was written in English like EXCEL it stuck 10 -15 years in the past Excel should be bigger and you should be able to write in normal English in SQL Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 18, 2005 Share Posted September 18, 2005 Jesus!!!!!!!!!!!!!!!!!! 34335[/snapback] Not quite the usual excel request, Rob? 34337[/snapback] It was the idea that anyone wouldlike ACCESS toTBH Link to comment Share on other sites More sharing options...
peasepud 59 Posted September 18, 2005 Share Posted September 18, 2005 Jesus!!!!!!!!!!!!!!!!!! 34335[/snapback] Not quite the usual excel request, Rob? 34337[/snapback] It was the idea that anyone wouldlike ACCESS toTBH 34635[/snapback] Hoo man! Im a child of the Windows generation, started out teaching myself DataEase and then automatically moved on at work into Access not out of choice but necessity. I dont have any problems with it and find that to do a quick dbase its ideal, drag and drop query design etc. Basically Im a lazy shite and cant be arsed to type all that SQL malarky. Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 18, 2005 Share Posted September 18, 2005 DATA EASE!!! Wow!! - my missus is/was a DE wizzard......... think we still have copy lurking around somewhere Link to comment Share on other sites More sharing options...
peasepud 59 Posted September 18, 2005 Share Posted September 18, 2005 DATA EASE!!! Wow!! - my missus is/was a DE wizzard......... think we still have copy lurking around somewhere 34653[/snapback] God I loved DataEase, it was fantastic. Link to comment Share on other sites More sharing options...
Craig 6682 Posted September 18, 2005 Share Posted September 18, 2005 you should be able to write in normal English in SQL 34634[/snapback] Errr.... you can! SELECT * FROM table_premiership WHERE table_premiership.team_name = 'Newcastle United'; Is about as normal English as you're gonna get in database syntax. You want a difficult database language, have a crack at UML or PROGRESS.... you'll soon find SQL a doddle... Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 19, 2005 Share Posted September 19, 2005 you should be able to write in normal English in SQL 34634[/snapback] Errr.... you can! SELECT * FROM table_premiership WHERE table_premiership.team_name = 'Newcastle United'; Is about as normal English as you're gonna get in database syntax. You want a difficult database language, have a crack at UML or PROGRESS.... you'll soon find SQL a doddle... 34915[/snapback] That's exactly what I mean - to computer nerds that code IS English to a normal user its not - its a weird bastardised version Like a lot of computer stufff it was developed in the '60's and '70's for IBM main frames or UNIX midi's and mini's when nerd talked to nerd and the great unwashed knew their place Tiem has moved on and we're still stuck with all this rubbish - I use a couple of programs that are STILL industry standard but were written in 1974-76 - and GOD! it shows............... Why can't you just write "I want newcastle United league position" - I guess Google is heading that way.................. Link to comment Share on other sites More sharing options...
Craig 6682 Posted September 19, 2005 Share Posted September 19, 2005 Why can't you just write "I want newcastle United league position" - I guess Google is heading that way.................. 34979[/snapback] Erm.... Because you're actually querying a computer and not a human being?? Jesus Wept Rob, a database can only return data on a specific query that has to follow logic. What's not simple about that code?? Do you class foreign languages 'nerdy' as well?? Try saying "I want Newcastle United league position" to a Mongolian goat herder, I'm sure you'd get a similar blank response... Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 19, 2005 Share Posted September 19, 2005 I gave up writing computer code in 1970 GET OPEN CLOSE WRITE IF:////$$$'MESSAGE'.ahsdghsdfsahgf6545363 God Bless XEROX and God Bless Mr Gates.............. Link to comment Share on other sites More sharing options...
peasepud 59 Posted September 19, 2005 Share Posted September 19, 2005 I gave up writing computer code in 1970 GET OPEN CLOSE WRITE IF:////$$$'MESSAGE'.ahsdghsdfsahgf6545363 God Bless XEROX and God Bless Mr Gates.............. 35100[/snapback] aye it just werent the same after some cocky fooker invented the keyboard was it? Heres some nostalgia for ya Rob...oh how I hark for the ease and simplicity of punching a hole in a predetermined position to store your code Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 20, 2005 Share Posted September 20, 2005 (edited) Wow! That was PROGRESS I started being able to read the holes in 5 column punched paper tape............. I can remember the first desk top I ever saw - it was at Uni and it was about 15 cm thick, 75 cm wide and 75 cm deep It took a specially prepared magnetic strip the size of the IBM paper punched card and would carry out 120 - yes I kid you not - 120 consecutive instructions It was used for astronomy and geochemical work and people came from a distance of 150 miles to see it work.................................. Edited September 20, 2005 by Rob W Link to comment Share on other sites More sharing options...
Guest Sima Posted September 20, 2005 Share Posted September 20, 2005 10 PRINT "NUFC" 20 GOTO 10 30 RUN Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 20, 2005 Share Posted September 20, 2005 BDOS Error on A Link to comment Share on other sites More sharing options...
Meenzer 15531 Posted September 20, 2005 Share Posted September 20, 2005 10 PRINT "NUFC"20 GOTO 10 30 RUN 36003[/snapback] Redundant tbh Link to comment Share on other sites More sharing options...
adios 717 Posted September 20, 2005 Author Share Posted September 20, 2005 Redundant tbh 36141[/snapback] I was wondering how long it would take someone to comment on that...NERD! Link to comment Share on other sites More sharing options...
Meenzer 15531 Posted September 20, 2005 Share Posted September 20, 2005 Redundant tbh 36141[/snapback] I was wondering how long it would take someone to comment on that...NERD! 36175[/snapback] Why thankyou. Link to comment Share on other sites More sharing options...
adios 717 Posted September 21, 2005 Author Share Posted September 21, 2005 Why thankyou. 36188[/snapback] I just had to type the command 'man mount' and for some reason it made me think of you! Link to comment Share on other sites More sharing options...
Meenzer 15531 Posted September 23, 2005 Share Posted September 23, 2005 Why thankyou. 36188[/snapback] I just had to type the command 'man mount' and for some reason it made me think of you! 36598[/snapback] I don't know whether to be honoured or faintly scared Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now