วันพุธที่ 31 ตุลาคม พ.ศ. 2555

[ 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.

ไม่มีความคิดเห็น:

LinkWithin

Related Posts Plugin for WordPress, Blogger...