Jump to content
wisem2540

How to store static data for scripts currently in Excel

Recommended Posts

wisem2540

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
JLogan3o13

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 ;)

 


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites
wisem2540

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
water

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-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
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

×