intoSql converter

  • IntoSQL

    IntoSQL

    IntoSQL

    This application into active development, please subscribe to get release notification.

    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
    • Tab separated text files (.tsv,.tab)
    • 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

    Application will transform hierarchical xml structure into flat table. All tags can have any name.Names of the tags will be used as names of tables and fields.

    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