How to convert excel sheet data to mysql ?

Question

I want to take all the excel data to mysql database.

Answer 1

Two ways: Cpanel or programming

In Cpanel, phpmyadmin, you can upload CSV formated files from your excell.

In php, you can use fgetcsv() function to read a CSV file line by line, and perform an insert every time.

(of course, it goes without saying that the CSV format must be identical to the table you are loading!!!)

Answer 2

If you are a good java programmer you can do this my programming by just getting java excel jars and implement to fetch records from excel and add to mysql tables.. simple

Answer 3

in preserving with the question on importing the Excel 2007 records to sq. Server 2005, i opt to grant you the concepts as follows: a million. Connection string undertaking: Please ascertain when you're powerfuble to connect both Excel 2007 and sq. Server 2005 because the records source effectively. The excelConnection seems to discover as you presented. Then that you may want to manage to also upload "HDR=particular" to point that the conventional row includes columnnames, now no longer recognize-how. "HDR=No;" shows the alternative. this may sidestep the first row at a loss for words at the same time as importing to the sq. tables. 2. Please try your ODBC sq. Server connection string in order that the relationship to sq. Server is ideal. except the ODBC, that you could also use SqlConnection and execute the SqlCommand merchandise with the announcement that includes the excelConnection for your VB.internet code, yet no longer in basic terms combine the completed in a unmarried sq. statement. correct the following article shows you the in basic terms right way: Import Excel sheet into table 3. except the above procedures, that you'll be able to do not ignore to apply SqlBulkCopy classification to import. correct the following article shows you the representation: Import Excel Spreadsheet tips into sq. Server Database table making use of SqlBulkCopy 4. there's a KB article in MSDN on the problem. besides the very undeniable reality that the article isn't utilized for sq. Server 2005, that you may want to as nicely be educated on sq. Server records Transformation facilities (DTS), Microsoft sq. Server 2005 Integration facilities (SSIS), sq. Server linked servers and sq. Server dispensed queries. they are major on your paintings. the right thanks to import tips from Excel to sq. Server wish that may help you.