|
This software 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. Excel 2000 or higher required. |
