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!

How to get your question answered on this forum!

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 (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - 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

×