 |
|||
PHP
IT Tags
UPDATE sdf magento ecommerce local server php mail control panel Combo box Remove Duplicate Simplexml Parser Solr XML local server SimpleXML include associative arrays mysql server connection to MYSQL my_thread_global_end PHP and FLash multiple file uplo server shutdown Mobile site check domain ajax Xampp XHTML indexing solr photo gallery objects Stop Script Overlapping Layers |
Excel to mysqlHello All, CommentsSave them in text format in Excel. They will be tab-delimited files. From there you have a much better chance of importing them into MySQL tables you have defined. Look at the MySQL command LOAD DATA INTO and note the properties such as SEPARATED BY and so on. If you have phpmyadmin then you can save then as CSV (Coma Separated Values) and the directly import them to an existing table with phpmyadmin. Do a test one first with an unused table. |
