UTILITIES


Excel Macro

VBA (EXCEL Macros) is a great tool that can improve productivity. Excel comes with a full programming language (VBA) that can access databases, create word documents and much much more.


Here is one example program "Upload.XML".

img

You want to upload a lot of data into a database, but it is a task that doesn't need to be done very often and you don't want to spent a lot of work on it.
One solution is to write a small VBA program that creates the commands to upload the data. Here are the steps: Download the excel sheet and look at the VBA program.
The link to the program is here.
Feel free to modify it yourself.

Other useful links the we use all the time