I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Database

One big issue with Excel © is the intrinsic mixture of data and of programs (formulas). VBA can help a bit here, but if you really want to separate the data from the programs you need to use a database.

My friend and former colleague Mike Robinson developed a tiny but powerful simple database. It consists of two tables and two stored procedures. I use this with MS SQL Server ©.

You can feed data into it via Excel and retrieve data with Excel.

1. Summary

2. System Documentation

3. User Documentation

4. Appendix (SQL Code)

5. Appendix (VBA Code)

If you are interested in downloading the 46 KB database documentation (pdf file) go to my Download page, please.

Sulprobil   Get it done   Contact   Disclaimer   Download