 |
|||
PHP
IT Tags
connection to MYSQL Mobile site ajax associative arrays SimpleXML local server photo gallery Xampp server shutdown local server UPDATE include indexing solr Simplexml Parser XHTML php mail objects control panel my_thread_global_end sdf magento ecommerce Stop Script check domain Remove Duplicate mysql server Combo box Solr XML Overlapping Layers PHP and FLash multiple file uplo |
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. |
