Geeklog Forums

You may have covered this elsewhere but I couldn't find it.

I had spreadsheets set up in Excel that I wanted to use as the basis for content in the Contacts plug in. After hours messing about getting the data into the right format (all columns identical to the table headings) I then found that it would not let me import the CSV file into my database.

I searched for ages to find something to import CSV into MySQL, then stumbled across here - it picks up your csv file off your computer and quickly translates it into MySQL (save as a .txt file) so that you can then run the MySQL command into your database.

This may be of use to someone.

Anon

Thanks for that! Saved me a bunch of work.

Thank you for your time and trouble .

Should have looked for this earlier. I have been trying to import a CSV for the last 6 hrs :banghead:

Great! Thanks :chestslam:

Good topic name, easy to found on google
Regards!

DUUUUDE :banana:

THANKS A LOT>.. can;t belive how usefull this was.

Congrats for the post... i'll ship you a 6pack of beer

Thank you so much! Awesome find, saved me a ton of time!

Hi, Thanks a lot. It rescued me from long sleepless nights. thanks a lot for sharing.

any other "csv2mysql" or "xls2mysql" freeware-tool that you know of?

my file is larger than 2MB

thx

I use for such cases software called BK ReplaceEM. It can replace some part of the text by another parts. Sure, if you found something special which converts CSV to MySQL it is better, however, many people often need similar changes and it may be easier to do it with such software than spending a lot of time by searching for something special.

Holy crap that is awesome. saved me soooo much time.

BTW captcha on this site SUCKS. makes some better images.

Thanks mate :-)

You're post came right on top off google :-)

very very thanks.

Anon.

You done a great thing.

Dear
another good tool for Excel7CSV import is http://www.dbTube.org
You can draw your import definition online with an workflow
editor. The generated improt definition can be used for your further
imports.

greetings

Andreas

http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/

Nice! Couple more methods: http://giantdorks.org/alain/export-mysql-data-into-csv-or-psv-files/

Hmm, let's see if I can get a link going: Export (and Import) MySQL data into CSV or PSV files :banghead:

Please send me the correct link for your post so that I can use it.
I have also the same problem. Thanx

mysql dbu is closed.
Any other alternative ?

You might try this link. There are a number of links to real software to suit this conversion requirement.

http://mysql-import-multiple-text-files-softwar.software.informer.com/

Often these sites are dynamic in nature so there's no guarantee as to how long the link will work.

If you have access to the data folder a simple alternative is to make a table of type CSV. (normally you have isam or innodb). Instantly you have the csv file in the folder. Just copy your data into it and its available in mysql or insert data into it using mysql and you have it in csv formt.

hope this helps,