[ SOLVED ] online converts excel sheet to SQL command tool ( MySQL, PostgreSQL, DB2, Oracle ) with quoted and numeric feature
input data in microsoft excel
My colleage dumps the DB2 database into the access file, and I would like to import it back to the DB2 database. This is the quick and dirty way.
After conversion from the excel to the SQL command, I execute that command in the DB2 command center. That's it !~
I built the quoted feature so that we can select which field we want to quote and not quote.
The tool is available at "Excel to SQL". Try it !
Step 1 : paste data from the excel, click submit
Step 2 : choose the column that we want to quote. if not selected the column will be treated as a numeric field
Step 3 : Bingo ! converted excel to SQL command
If we want to convert from the fix length file ( i.e. the database output file exported from SPUFI ) to the excel sheet, I suggest you to use .rtf format. The microsoft excel understand .rtf and we can correctly parsed it into the column of the excel table.