Excel Convert File To SQL Statements (Commands) Software
-
Version
7.0
This software offers a solution to 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.
|