December 3rd, 2013
How to Use Excel to Script Database Table Updates
An easy way to set-up/prepare a database table update is to use built-in excel functionality to wrap the source data in TSQL commands.
More
Excel
-
-
February 19th, 2013When Do I Need to Upgrade From My Spreadsheets to a Database?
MoreSpreadsheets are easy to use, flexible and inexpensive, but depending on your project, a database may be better for storing your data.