This app offers a solution for users who want to create SQL statements based on rows in one or more Excel files. The user adds the file/s or an entire folder for processing. The table name and table delimiting character are entered before choosing an option to: use the create table command with the first row followed by the insert command or to use the insert command on all rows.
There is a check box to allow insertion of ';' at the end of each line and options to apply changes to a specific block of cells, the active sheet or the entire workbook. There is an option for reading the Excel file from left to right or up and down. The results are displayed in the large pane on the right and can be saved as a text file or copied to the clipboard for pasting.
Comments