Fixing Excel Dates

One of the problems that often comes up when working with Excel programmatically is that dates are often converted to American date format automatically. So for instance you might open a csv file with the value ’07/11/2016′ in dd/mm/yyyy format only for...

Dealing with Commas in CSV Files

CSV files are ubiquitous ā€“ they are the most common means of transferring data from one system to another using a text file. They do, however, have one major drawback ā€“ commas. A string of comma separated values is no problem when all the values are numbers or text...

Running an Access Database on your Phone

As the world becomes more mobile and cloud orientated, I have been working hard trying to get a database to run on a smart phone in some form. Ultimately Iā€™d like to host a database in the cloud and then be able to use Access as an interface not only on a desktop PC...