Welcome to Geeklog, Anonymous Sunday, November 10 2024 @ 07:45 pm EST
Geeklog Forums
Useful tool - CSV to MySQL
Page navigation
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
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
51
34
Quote
Turadg
Anonymous
Thanks for that! Saved me a bunch of work.
40
30
Quote
Philip
Anonymous
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:
Should have looked for this earlier. I have been trying to import a CSV for the last 6 hrs :banghead:
33
34
Quote
blue
Anonymous
Great! Thanks :chestslam:
Good topic name, easy to found on google
Regards!
Good topic name, easy to found on google
Regards!
36
36
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
THANKS A LOT>.. can;t belive how usefull this was.
Congrats for the post... i'll ship you a 6pack of beer
33
40
Quote
ANON
Anonymous
Thank you so much! Awesome find, saved me a ton of time!
40
34
Quote
Pranjal
Anonymous
Hi,
Thanks a lot.
It rescued me from long sleepless nights.
thanks a lot for sharing.
26
38
Quote
irelandsnexttopmodel
Anonymous
any other "csv2mysql" or "xls2mysql" freeware-tool that you know of?
my file is larger than 2MB
thx
my file is larger than 2MB
thx
44
35
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.
36
27
Quote
Tom
Anonymous
Holy crap that is awesome. saved me soooo much time.
BTW captcha on this site SUCKS. makes some better images.
BTW captcha on this site SUCKS. makes some better images.
50
27
Quote
Compi
Anonymous
Thanks mate :-)
You're post came right on top off google :-)
You're post came right on top off google :-)
28
42
Quote
Ganesh
Anonymous
very very thanks.
Anon.
You done a great thing.
Anon.
You done a great thing.
37
29
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
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
34
31
Quote
kedar
Anonymous
http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/
30
35
Quote
Giant Dork
Anonymous
Nice! Couple more methods: http://giantdorks.org/alain/export-mysql-data-into-csv-or-psv-files/
37
40
Quote
alain
Anonymous
Hmm, let's see if I can get a link going: Export (and Import) MySQL data into CSV or PSV files
:banghead:
35
41
Quote
Moses
Anonymous
Please send me the correct link for your post so that I can use it.
I have also the same problem. Thanx
I have also the same problem. Thanx
44
31
Quote
Kris
Anonymous
mysql dbu is closed.
Any other alternative ?
Any other alternative ?
31
39
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.
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.
32
34
Quote
joel box
Anonymous
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,
hope this helps,
29
32
Quote
Page navigation
All times are EST. The time is now 07:45 pm.
- 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