Welcome to Geeklog Tuesday, May 21 2019 @ 08:54 am EDT

Geeklog Forums

Useful tool - CSV to MySQL


Status: offline

Anon

Forum User
Junior
Registered: 18/10/06
Posts: 21
nerdy
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

Turadg

Anonymous
caffeinated
Thanks for that! Saved me a bunch of work.

Philip

Anonymous
excited
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:

blue

Anonymous
Great! Thanks :chestslam:

Good topic name, easy to found on google Big Grin
Regards!

Alexrus

Anonymous
DUUUUDE :banana:

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

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

ANON

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

Pranjal

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

irelandsnexttopmodel

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

my file is larger than 2MB

thx

Status: offline

MoneyTopList

Forum User
Newbie
Registered: 21/11/09
Posts: 1
Location:Orihuela Costa, Spain
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.

Tom

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

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

Compi

Anonymous
Thanks mate :-)

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

Ganesh

Anonymous
very very thanks.

Anon.

You done a great thing.

Andreas Herz

Anonymous
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

kedar

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

Giant Dork

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

alain

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

Moses

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

Kris

Anonymous
mysql dbu is closed.
Any other alternative ?

Jim

Anonymous
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.

joel box

Anonymous
cheerful
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,

All times are EDT. The time is now 08:54 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content