Skip navigation links

MySQL Forums


Advanced Search

Re: import from Excel to MySQL
Posted by: Davorin Jelen ()
Date: September 20, 2004 07:19AM

Simply export data from excel as TXT or CSV. Than use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;





Options: Reply•Quote


Subject Views Written By Posted
import from Excel to MySQL 119644 m ds 09/10/2004 04:53AM
Re: import from Excel to MySQL 68830 Davorin Jelen 09/20/2004 07:19AM
But LOAD DATA does not take care of relationships 31330 Ashwin Kamath 10/15/2004 03:41AM
Re: But LOAD DATA does not take care of relationships 24238 Dana Henderson 10/15/2004 05:07AM
Re: import from Excel to MySQL 31519 Manish Sharma 08/18/2005 12:00AM
Re: import from Excel to MySQL 28405 tapan rath 09/05/2005 10:45PM
Re: import from Excel to MySQL after save it in txt format 23085 saurabh kumar 07/12/2007 10:17PM
Re: import from Excel to MySQL 15176 gandham ramesh 04/15/2008 04:14AM
Re: import from Excel to MySQL 23745 Dana Henderson 09/26/2004 02:30PM
Re: import from Excel to MySQL 18315 Thomas Schneider 02/01/2005 06:05AM
Re: import from Excel to MySQL 14414 Erwan Pianezza 01/25/2006 07:49AM
ESF Database Convert 14773 h qy 06/19/2006 09:02PM
Re: import from Excel to MySQL 12492 james zimmerman 04/11/2007 07:52PM
Re: import from Excel to MySQL 9110 Balamurugan Jagadeesan 05/17/2007 11:18AM
Re: import from Excel to MySQL 4720 mikel gorge 09/10/2008 08:32AM
Re: import from Excel to MySQL 9085 Raphael Mazar 07/07/2007 08:11AM
Re: import from Excel to MySQL 10559 Karanjkar Durgesh 10/08/2007 10:11AM
Re: import from Excel to MySQL 8012 john crane 11/04/2007 12:36PM
Re: import from Excel to MySQL 6149 Vu Mai 02/26/2008 03:43PM
Re: import from Excel to MySQL 7440 Vu Mai 02/26/2008 03:49PM
Re: import from Excel to MySQL 5930 Vu Mai 02/27/2008 05:32PM
Re: import from Excel to MySQL 6028 arat rana 03/19/2008 03:49AM
Re: import from Excel to MySQL 6260 frank Don 03/24/2008 05:58PM
Re: import from Excel to MySQL 2343 Iresh Patel 03/14/2009 07:55AM
Re: import from Excel to MySQL 6689 Alcide Burato 05/18/2008 08:55AM
Re: import from Excel to MySQL 2738 Titus Hui 03/07/2009 11:33PM
Re: import from Excel to MySQL 6444 yamen ajjour 07/07/2008 12:17AM
Re: import from Excel to MySQL 5650 Dmitry Narizhnykh 02/24/2009 04:03AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum