View Single Post
  #19  
Old 14th August 2006, 04:16 PM
OZDOC OZDOC is offline
Member
 
Join Date: Jan 1970
Posts: 40
Default

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 )
Reply With Quote