If you have a table in Excel with the proper column headings, all that you need to do is copy and paste the data and column headers into the data entry text box below AND insert a row at the top with just the table name. ODBC and fancy DB GUIs are nice but regular SQL can be used anywhere. The original goal of this tool was to abstract and simplify exporting data from Excel to a database (MySQL specifically). INSERT INTO apple (types,color,size) VALUES ('gala','yellowish','small') INSERT INTO apple (types,color,size) VALUES ('golden','red','varies') INSERT INTO apple (types,color,size) VALUES ('mac','reddish','medium') INSERT INTO apple (types,color,size) VALUES ('golden','yellow\'s my favorite colour','large') Line 2 is a tab separated list of field names. The format that you MUST follow is this: Line one has the table name only. This tool will take specifically formatted data that is copy and pasted from Excel (and possibly other spreadsheet programs) and convert them into SQL INSERT commands. The Excel-to SQL INSERT Commands Text Wizard!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |