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