Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 05:22 am EDT

Geeklog Forums

Useful tool - CSV to MySQL

Page navigation


Status: offline

Anon

Forum User
Junior
Registered: 10/18/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
 Quote

Turadg

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

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:
 Quote

blue

Anonymous
Great! Thanks :chestslam:

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

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
 Quote

ANON

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

Pranjal

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

irelandsnexttopmodel

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

my file is larger than 2MB

thx
 Quote

Status: offline

MoneyTopList

Forum User
Newbie
Registered: 11/21/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.
 Quote

Tom

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

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

Compi

Anonymous
Thanks mate :-)

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

Ganesh

Anonymous
very very thanks.

Anon.

You done a great thing.
 Quote

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
 Quote

kedar

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

Giant Dork

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

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:
 Quote

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
 Quote

Kris

Anonymous
mysql dbu is closed.
Any other alternative ?
 Quote

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

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,
 Quote

Page navigation

All times are EDT. The time is now 05:22 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