CSV to MySQL
Submitted by admin on Thursday 04th of October 2007 09:52:34 AMRecently I had a CSV file which contained about 2000 entries that needed to be converted into a MySQL file.
I tried several different PHP converters which worked okay for smaller files but not as well for this one as it contained lots of data and different characters.
The solution I found to this was to open the CSV in MS Excel, save it as a MS Excel file. Then import that file into MS Access and save it.
Then I downloaded MS Access to MySQL from http://www.bullzip.com/products/a2m/info.php and created a MySQL dump file.
This file I was then able to import into MySQL and everything worked 100%.
Where there is a will there is a way, using multiple programs to convert files into necessary format is a great way to solve this sort of problems.
I am a big fan of using programs such as textpad to remove unwanted formating in files as well.
Comments
