Differences

This shows you the differences between two versions of the page.

--- projects:digikey_partsdb [2013/10/12 10:48] – charliex
+++ projects:digikey_partsdb [2013/10/13 10:11] (current) – charliex
@@ Line 1001: / Line 1001: @@
 for %a in (*.csv) do byteskip %a o%a 4
 </code>
+I used one of the online CSV to MYSQL converters, but most of them can't handle the variations in CSV. To create the initial schema for each table i converted one CSV to XLS by importing it into google docs, and then re-exporting it as an XLS then importing that into phpmyadmin, that makes the base schema.<br>
+Rename the table in phpmyadmin or via mysql tool
+Then do the final import with the csvtosql tool, (in progress)