
14th August 2006, 04:16 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 40
|
|
QUOTE=Chrome Prince]The data files are not optimized to handle LARGE amounts of data.
??? the new version of excel has over 1 million rows ( may be wrong ) but even the current sytem can handle Large data, but i may be wrong again
By corruption, I mean the file system collapsing (not being able to read the data.
incorrect i have many large files that do not break down
Try storing 60,000 rows of data in Excel, it will crash eventually.
i do / have and no problems
If you think I am wrong and want proof, just google "Excel corrupt" and "Excel crash" and see the hundreds of postings and "tools" available to try and reclaim data.
i dont wish to go down the your wrong i am right path but just to so it has proven stable when set up right for me
There is even an obvious hint by Microsoft in the Microsoft Application Recovery tool, the saved document library, (which is why by default, Excel saves itself every 20 minutes or so) and the Microsoft Knowledge Base.
this is an option that can be turned of and excel has had auto save for some time
Excel is designed for spreadsheets, analysis and reporting, not storing large amounts of data, which is why you are limited to 65,336 rows of data, the absolute edge of the precipice.
as above new version 1 million
I know from experience, when I first started using Excel as a database with 45,000 rows of handtyped data exploded to be unrecoverable and a year's work disappeared forever into the ether.
??? not sure why it happened to you
I also have a copy within my Access database, and a copy within my Filemaker database, should anything go wrong with any of them
agree copies of anything are important, but stating that excel is open to coruption is not from my experiance true and i push it to every boundry known. In that all is peace here just was not sure regarding your comment, but will re state if set up well excel will not corrupt a file. ( from my experiance )
|