wisem2540

How to store static data for scripts currently in Excel

4 posts in this topic

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

 


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

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 (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

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