intoSql converter

Reactions:
  • IntoSQL

    IntoSQL

    IntoSQL

    IntoSQL is an application for converting data tables from different file formats into SQL script including Create Table and Insert instruction.

    Input file formats includes:

    • Excel
    • CSV
    • XML
    • JSON
    • Tab separated text files
    • Word
    • HTML

    If First row contains columnt names option is selected then first row will be used as name of table fields into CREATE TABLE statement. Please notice that all non-valid SQL characters will be removed from table name and fields names. Data from all following rows will be used as Values for data table.

    Also there are some specifics for converting different files:

    Creating SQL from Excel files

    When Excel file is selected intoSQL will create table for every Sheet into Excel document. Name of the sheet will be used to create table name.

    Making SQL from CSV files

    Name of the CSV file will be used as table name. If First row contains columnt names option is selected then first row will be used as name of table fields into CREATE TABLE statement.

    Producing SQL from XML files

    Xml file should have following structure.

        <root-tag>
            <table-tag>
                <row-tag>
                    <field-tag>

    All tags can have any name.Names of the tags will be used as names of tables and fields.

    Converting JSON file into SQL

    Json file should have following structure:

    Creating SQL from tables into HTML file

    Application will convert data into inside html table tags into script.
    For example if html code is following:

        <table id='Orders'>
            <th>OrderId</th>
            ...
            <td>Order#1</td>

    New Orders table will be created. Data specified into th tags will be used for column names. And whatever is into td tags will be used for Insert statements.

    Creating SQL from tables into Microsoft Word files

    Application will read Microsoft word file and convert all data specified into tables into scripts. If First row contains columnt names option is selected then first row will be used as name of table fields into CREATE TABLE statement.

No comments:

Post a Comment