wisem2540 Posted November 18, 2015 Share Posted November 18, 2015 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. Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted November 18, 2015 Moderators Share Posted November 18, 2015 It depends, you need to define "some data":Is it one line? Save it in an INIIs it 100 rows? Save it in ExcelIs 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 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
wisem2540 Posted November 18, 2015 Author Share Posted November 18, 2015 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. Link to comment Share on other sites More sharing options...
water Posted November 18, 2015 Share Posted November 18, 2015 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now