Archives
Finding and Deleting Duplicates in Excel
Posted in August 12th, 2007
Published in Data and Databases, Excel
Sometimes when working with large excel spreadsheets, you run into the problem of duplicates, and it helps to be able to find them and delete them without having to manually go through the spreadsheet. If you have two or more columns of data, and you need to find and delete the duplicates, this is […]
(No Comments)
From csv to sql - in brief
Posted in August 7th, 2007
Published in Data and Databases
In my last few posts I explained in a four-part tutorial how to convert a csv file to a sql file. I am going to summarize the steps in this post so that you have them all in one reference post. The tools that I prefer for this process are PHPMyAdmin and HeidiSQL, and […]





