+ Reply to Thread
Results 1 to 12 of 12

Software to replace Excel or Access

  1. #1
    Registered User
    Join Date
    02-26-2008
    Posts
    21

    Software to replace Excel or Access

    I have an Excel spreadsheet I use as a keeper of records; 100 unique rows/records with approximately 10 columns of data. These columns are filled with 2 digit codes, a word or short phrase. So using Excel was effective. However I will be adding 2 or 3 additional columns to this spreadsheet that will be text oriented (one cell could have multiple paragraphs of text). I need to move away from Excel and I know I could use Access with some enhanced reporting, but I would rather use a vended product that is designed for this type of work. Best I can describe what I am looking for is an electronic file cabinet.

    In summary; I am looking for suggestions for a vended software that can house a small database (two hundred records max) with 10 – 15 bits of data per record, some records would be numerical, some would be lengthy text (let’s say 1000 words per). Would need to be flexible to generate a report in a summary fashion (all records with a subset of data), and be able to generate a single record report that shows all data including the lengthy text.
    Any ideas? Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Software to replace Excel or Access

    Why do you think that excel would not be able to do this for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Software to replace Excel or Access

    I recommend excel instead of access...
    Because access has 255 columns limit...
    I never understand why people prefer access instead of excel
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Software to replace Excel or Access

    Quote Originally Posted by HerryMarkowitz View Post
    I never understand why people prefer access instead of excel
    Becasue access can handle far greater volume of data, generally far quicker than than excel can. It's a case of teh right tool for the job

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Software to replace Excel or Access

    Quote Originally Posted by FDibbins View Post
    Becasue access can handle far greater volume of data, generally far quicker than than excel can. It's a case of teh right tool for the job
    I dont understand this...
    Access column limit is 255.
    So, how access can handle far greater volume of data?

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Software to replace Excel or Access

    columns - 255
    rows (records) almost unlimited

    Try working with a million records in excel

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Software to replace Excel or Access

    Herry

    If you are going anywhere near that limit in Access you need to rethink the design of your database.
    If posting code please use code tags, see here.

  8. #8
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Software to replace Excel or Access

    I will always prefer excel...
    I will always prefer Excel Binary Workbook Format (.xlsb) if I have huge data...
    I will always hate access...

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Software to replace Excel or Access

    Quote Originally Posted by HerryMarkowitz View Post
    I will always prefer excel...
    I will always prefer Excel Binary Workbook Format (.xlsb) if I have huge data...
    I will always hate access...
    right tool for the job, but to each their own

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,413

    Re: Software to replace Excel or Access

    My understanding was always that Access was ideal for relatively small databases. Can't recall now what the definition of "relatively small" was but it wasn't a million, and it wasn't unlimited. Add to that the cost of purchasing the product on top of the other Office components, the learning curve associated with developing anything other than a very simple database, AND the fact that you probably still need Excel to analyse the data effectively ... If a database is required, it would probably be better to use mySQL and instal the Excel/MySQL Add-in.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  11. #11
    Registered User
    Join Date
    02-26-2008
    Posts
    21

    Re: Software to replace Excel or Access

    Answers to several posts:

    Excel will work for this process, and I also agree the Access character limit would be an issue. What I did not underscore is the most important attribute needed: the ability to spit out a report in summary form which Excel would do nicely (if you exclude the paragraphs of text), and more importantly the ability to generate a report format of all details of a single record. One report record may be a single page, another may be several pages in length. Given the changing size and format of this report, I do not want to work around the limitations that exists in Excel reporting. I set up a very nice Word template recently with fields that expand as needed. It is that type of functionality that I am looking for. So in summary think of the functionality a word processor housed within a database that can be summarized based on specific record attributes.

    And, yes some VBA code and Crystal reporting would probably get me where I need to be. However my IT department frowns on writing code in support for an ongoing endeavor especially one in which the originator (me) will not likely own the process in the long term. Thus the search for a vended product. Thanks all for your feedback!

  12. #12
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Software to replace Excel or Access

    If you've already got access, it's worth starting there, there is no "character limit" in access.

    Reporting is trivial and you can mail merge into Word if you like, no code required

    If you want an actual application, you may get some mileage out of evernote, it will do all the things you've asked for, though you've not been especially clear
    Last edited by Kyle123; 05-12-2015 at 10:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. What other software can make my excel file secure? MS Access?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2013, 10:11 PM
  2. how to make upload of Excel sheet for access software
    By roofi in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-11-2013, 01:00 AM
  3. how to make upload of Excel sheet for access software
    By roofi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2013, 10:04 AM
  4. Accounting Software through Access Database question
    By stevetothink in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-23-2013, 09:52 AM
  5. Best software to access files on remote PC via Internet?
    By JapanDave in forum The Water Cooler
    Replies: 14
    Last Post: 01-28-2012, 06:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1