Excel ke MySQL

baddai · #1 (**permalink**) 01-10-2003, 09:46 PM

cam maner aku nak pindahkan database aku dari excel kree MySQL dengan cara yang lebih murah.. aku search untuk converter, tapi semua ne berbayar... ade cara lain kree nak pindahkan data aku tu..

sufyan · #2 (**permalink**) 01-10-2003, 11:07 PM

I don't really know a simple way to do this, but a way I do it is import the Excel data to a MS Access database, which is done by using File > Get External Data > Import

Once you have imported excel to a MS Access database, you can create a php script to do all the grabbing and dumping. You could use something like below. It's some code I wrote to import data from excel sheets to MySQL.

However, there might be easier ways to do it, try searching on google or something.

PHP Code:


			
<?php

// This opens up the Access database using ODBC

$cnx = odbc_connect('exchange','root','');

// This selects the table in your Access database

$result = odbc_exec($cnx, "SELECT * FROM Country");



// The standard loop thing

while ($myrow = odbc_fetch_row($result)) {

    // Connect your your MySQL database

    $db = mysql_connect("localhost", "root", "");

    // Select your MySQL database

    mysql_select_db("hc_system", $db);

    // The below 2 lines insert the grabbed data (from Access) into MySQL

    $sql = "INSERT INTO country (CountryCode,Country,Region,Currency,CurrencyCode) VALUES ('" . odbc_result($result, 2) . "','" . odbc_result($result, 3) . "','" . odbc_result($result, 6) . "','" . odbc_result($result, 5) . "','" . odbc_result($result, 4) . "')";

    $result2 = mysql_query($sql);

    // This just prints what has been dumped

    echo "Done - " . odbc_result($result, 2) . "<br>";

}

?>

DingDang · #3 (**permalink**) 01-11-2003, 10:18 AM

..or you can convert your excel data into CSV (comma seperated value) and import it into mysql using mysql gui such as Sqlyog or mysqlFront.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ASP.NET - DataGrid Export to Excel - Alignment problem	genzy	Website Programming	2	15-04-2007 11:21 AM
mcmana nak export excel ke mysql	poshberry	Website Programming	15	04-06-2004 04:29 PM
can excel VBA 97 be converted to XML?	ymhy_80	Website Design	1	26-02-2004 01:15 PM
convert excel vba to webpage	ymhy_80	Websites Review and Suggestion	1	20-02-2004 11:50 AM
transfer excel filr to powerpoint	khairudin	Mamak Stall	1	21-07-2003 01:16 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)