you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Shobhit , an ibibo Master, at 7:07 PM on August 05, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Hemant Singh , an ibibo Master, at 5:11 PM on August 04, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Raksha , an ibibo Master, at 2:53 PM on July 30, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Rocky , an ibibo Master, at 11:12 AM on July 23, 2008

well, you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

http://www.softaward.c om/92 17.html

http://www.websited ataba ses.com/excel-mysql.html

Tr y these so many Open source tools also available

Answered by Uttam , an ibibo Master, at 3:48 PM on July 21, 2008

well, you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

http://www.softaward.c om/92 17.html

http://www.websited ataba ses.com/excel-mysql.html

Tr y these so many Open source tools also available

Answered by Romi , an ibibo Master, at 8:48 PM on July 20, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Ni .. , an ibibo Master, at 4:23 PM on July 20, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by R.P. Singh , an ibibo Master, at 7:38 PM on July 17, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

Answered by Arvind Pal , an ibibo Master, at 6:56 PM on July 17, 2008

you can tried using the excel import function that comes with phpmyadmin http://www.phpmyadmin.net/home _page / - it does not require any additional plug-ins or scripts and is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish to import the data to , there is a link on the bottom left corner which says "insert data from a text file into the table" - although it says text file it still can be used to import an excel file. When you click on this link you will be taken to a page where you will be asked for the file name (the excel file should be saved as a csv file), how the fields in the file are terminated (you would change this to a "," without the quotation marks), and other data formatting attributes (these are usually left blank).

you have a in-memory representation of the data to insert? simply loop throu it and make "insert"s ine the database using jdbc... It seems hard coding your task a bit. There are many tools to convert your Excel in to MySQL.so try them

http://www.softaward.c om/92 17.html

http://www.websited ataba ses.com/excel-mysql.html

Answered by Madhurima , an ibibo Master, at 6:40 PM on July 17, 2008