Jump to content
wisem2540

How to store static data for scripts currently in Excel

Recommended Posts

I am developing a front-end application to look up some data.  The Data remains pretty static and only updates like twice a year.  How would you store this?  Currently, its in Excel, but I would like something a little more transparent, like a MySQL DB.  I welcome any suggestions.

Share this post


Link to post
Share on other sites

It depends, you need to define "some data":

  • Is it one line? Save it in an INI
  • Is it 100 rows? Save it in Excel
  • Is it 50000 rows with 10 columns each? Then maybe SQLite is the way to go.

You need to give us better information in order to help you ;)

 

Share this post


Link to post
Share on other sites

Sorry about that.  Its probably 5,000 lines.  The performance using excel is fine.  I just didnt know if there would be a more "Professional" way to do it.

Share this post


Link to post
Share on other sites

If Excel fits your needs (fast enough, you know how to read/write data etc.) then I would stick with it. "More professional" is a bit vague :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2019-03-02 - Version 1.3.5.0) - Download - General Help & Support - Example Scripts - Wiki
Outlook Tools (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...