CSV to MySQL Conversion Tools?

Status
Not open for further replies.

mneylon

Administrator
Staff member
Can anyone recommend any CSV to MySQL conversion tools?

I've got a flatfile database which has a series of fields that I need to import into MySQL.
Most of the fields in the orginal will map to new ones in the MySQL, while some on both sides will be ignored

Any recommendations welcome :)
 

mneylon

Administrator
Staff member
Unfortunately I need to do more than just load the CSV in if you look at my original post
 

dave

New Member
This is not a tool as such, but my method for doing this.

If I am reading this correctly you have for example in the csv fields
id, name, address, csvIgnore1, csvIgnore2
and in the mysql fields
id, name, address, mysqlIgnore1, mysqlIgnore2
where you want to map id, name, address, and ignore other fields.

The way I usually do it, is to get all the fields in the csv to match the
fields in the mysql database and then import it using the import tool in phpMyAdmin.

I usually import the cvs into microsoft access (or create a new mysql database) delete the fields I don't want and create the fields to match the existing mysql database. Then export it as csv and do an import in phpMyAdmin to the existing database.
 

daviddoran

New Member
I made something like this a while back for exporting data to CSV, changing it and then importing back in. If you want I'll modify it to let you drop columns etc.
 

mneylon

Administrator
Staff member
I made something like this a while back for exporting data to CSV, changing it and then importing back in. If you want I'll modify it to let you drop columns etc.
That would be nice :)

Aren't there any desktop apps that do this already though?
 

mneylon

Administrator
Staff member
I got it sorted out.. A programmer friend did the import for me :)

I just have to manually sort out the data
 
Status
Not open for further replies.
Top