Why spend all day migrating an Excel table with 100 columns and 10,000 rows through
tedious coding when you could do it in 60 seconds? Your time is valuable. Make the most of it.
<--DOWNLOAD TRIAL COPY-->
(After downloading, it should be in your download folder but you will have to right click on the file,
choose Properties and check Unblock to work. Feel free to scan it for viruses though if you are nervous. It's safe.)
A tool for converting Excel tables to multiple formats such as:
CSV, Tab and Pipe Delimited text, XML, JSON, MongoDB,
Javascript Arrays, Python Lists, Arrays Tuples and Data Frames
Along with code to build tables and insert rows into
Oracle, SQL Server, Sybase, Access, MySQL, PostgreSQL, DB2 and SAP.
Import Data:
Choose a Database Type and Make a Table:
Create Table Code
Build Insert Statements
Generate Python Code:
Simple XML(without the style sheet formatting)
Make Tables in SAP:
Fill Tables in SAP:
The Blue and Orange tabs have Import Buttons to open the Import Form shown below.
You can paste a table into the Paste Page, or import your own sheet
through Move or Copy and it will appear in the listbox below
so you can import it to the orange or blue tabs.
Once data is imported You can choose a Database type like Oracle, SQL Server, Access, Sybase,
PostgreSQL, SAP, DB2 or MySQL. Then hit Create Table to generate field names, types and lengths
After hitting Create Table, it will run down columns
determining if they are numbers or dates, and if not text, and populate the Create Table tab
below with some defaults. It also sets field lengths based on the existing max in columns
The Make SQL button writes Create Table code and fills a text file with it.
But you can change the types and lengths before hitting Make SQL for customization.
Once the table is created in Oracle, SQL Server, Sybase, Access, MySQL or PostgreSQL,
you hit Insert Code here to generate a text file with Insert statements(some of them pretty large).
But all orange and blue tabs have an Import button as well.
For example, if you import your data into the Python tab and hit Write
It will open a form to let you chose tye kind of code you want
Hitting a Write button on that form will open a text file with Python code.
Note: You can delete the green tabs. The Northwind sheets are
just used for test data, having a lot of foreign characters.
Pretty self explanatory. Import data and hit Write
To convert the Excel table into JSON.
Same with Javascript. Import data and hit Write
To convert the Excel table into a Javascript Array.
After importing into the MongoDB tab it will also make some
guesses about data types to set up a text builder.
It can write SAP code to make tables
Then fill tables in SAP:
ACCESS SMART FORMS
A tool for analysis, querying, reports and export to Excel.
products@querytools.net or
suppport@querytools.net