Click to See Complete Forum and Search --> : convert csv to sql


madman0
06-01-2008, 03:36 AM
Hi there,

Lately I have been asked to convert a large volume of csv files to mysql. I thought that it would easier but I was obviously wrong.
The main issue is that whenever I try to "import" csv to mysql (using PHPMyAdmin) the data get screwed in the process.
I need a script that knows the difference between INT, VARCHAR and DATETME.

Pls help

chazzy
06-01-2008, 09:12 AM
"screwed" is such a generic term. can you be more specific?