Avatar of garyrobbins
garyrobbins
Flag for United States of America asked on

Program Recommendations for Larger Data Sets

Hello All

I don't have a question per say but I was looking for recommendations.  I love Excel and Access however I am working with LARGE amounts of data, often over 800,000 lines with as many as 65 columns and my excel and access crash all the time.  Does anyone have any suggestions for programs that have the same functionality as Excel and Acces but can handle more data?  Or even better a way to continue to use excel but get it to function better with more data?
Microsoft ExcelMicrosoft Access

Avatar of undefined
Last Comment
Manfred Bertl

8/22/2022 - Mon
Manfred Bertl

i'd recommend Libre-/Open-Office. I had the same problem with Excel handling large amount of data. While Excel crashed all the time, LibreOffice Calc could deal with it. Since then i work with Calc and can do everything.
garyrobbins

ASKER
Ill Check it out thanks.

How well does it convert to excel?  I will still need to send out reports in excel format?
ASKER CERTIFIED SOLUTION
Manfred Bertl

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy