Excel – using VLOOKUP to remove rows based on matching data from another column

Posted by Shek on December 10, 2012 under Misc | Be the First to Comment

In this post, I will demonstrate how to remove rows which are not matching the records in the other column of Excel with VLOOKUP. Although I am using Excel 2010 for the demonstration but this method should work with Excel 2003 as well.

Read more of this article »

Import Excel, CSV file data into MySQL database table

Posted by Shek on August 20, 2008 under MySQL | 4 Comments to Read

To import Excel data into the MySQL database’s table is easy. All you have to do is to save the Excel file as “CSV” Format, and use phpmyadmin to complete the job for you. Here I have create an example to show you how to do so:

Read more of this article »