Microsoft Excel is one of the most widely used programs in the world. It allows users to easily manipulate data and make quick and accurate calculations. Intelligent Converters team makes Excel spreadsheets even more useful by building reliable bridge between MS Excel and the most popular databases. It is Excel Export Kit, software pack to export data from MS Excel files to MySQL, Oracle and MS SQL databases.Features include where all versions of MS Excel are supported (including MS Excel 2010),all versions of MS SQL starting from 7.0 are supported,all versions of Linux/Unix and Windows MySQL are supported,all versions of 32- and 64- bit Windows and Linux/Unix Oracle servers are supported,option to convert individual worksheets,option to merge MS Excel data into an existing database and converts Comma Separated Values (CSV) files into tables
Excel Export Kit
Microsoft Excel is one of the most widely used programs in the world. It allows users to easily manipulate data and make quick and accurate calculations. Intelligent Converters team makes Excel spreadsheets even more usefull by building reliable bridge between MS Excel and the most popular databases. It is Excel Export Kit, software pack to export data from MS Excel files to MS SQL, MySQL, Oracle and PostgreSQL databases.
Features
All versions of Microsoft Excel are supported (including MS Excel 2012)
Migrates MS Excel data to MS SQL Server (all versions of MS SQL are supported including Azure SQL)
Migrates MS Excel data to MySQL (all versions of Linux/Unix and Windows MySQL are supported)
Migrates MS Excel data to Oracle server (all versions of 32- and 64- bit Windows and Linux/Unix Oracle are supported
Migrates MS Excel data to PostgreSQL server (all versions of PostgreSQL starting from v9.0 are supported)
Option to convert individual worksheets
Option to customize types mapping and select certain columns to convert in Excel-to-MSSQL and Excel-to-MySQL tools
Option to merge MS Excel data into an existing database
Converts Comma Separated Values (CSV) files into tables
Intelligent types mapping
Stores conversion settings into profile
Quick Launch
Command line support
Easy-to-use wizard-style interface
Full install/uninstall support
Requirements
Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10, Linux with WINE
Microsoft Excel/Office or Access Runtime installation
MS SQL environment (to make Excel to MSSQL conversion)
Necessary privileges to write into the destination database
Quick Lauch
Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description file with left mouse button. This will cause the corresponding OraDump export tool to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.
« left
The Intelligent Converter team is very helpful and responsive. We have also received custom versions of the tool. Melanie Paris, SNAP Inc.
I got the table, thank you for providing such a wonderful tool! Many thanks from my bottom of the heart I am soo happy!
Customize table structure
Manual table structure customization can be accessed by double click on the corresponding table name in “Selected tables” list of “Select Tables” wizard page. This will cause the following dialog box to appear:
To customize type mapping select the appropriate item in the listview on the left and specify new name, type and default value for the field using “Field info” group of controls. Please note that listview on the left contains column attributes of the original types mapping, new custom types and attributes will be displayed in “Field info” controls when the corresponding item is highlighted in the listview.
Free subscription for updates
As every Intelligent Converters product, Excel Export Kit is supplied with one year subscription for updates. It means that you will receive new versions of the software included in Excel Export Kit for free within one year. Moreover, you will receive all new utilities for export data from MS Excel that will be released during your subscription period.
Try before you buy
Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.
Ordering
Intelligent Converters software is distributed through downloading from our server only. For online credit card purchasing select the desired software package in the table below and click the corresponding ORDER NOW link. To learn about alternative payment options please visit our Ordering Page.
Microsoft Excel is one of the most widely used programs in the world. It allows users to easily manipulate data and make quick and accurate calculations. Intelligent Converters makes Excel spreadsheets even more useful by building a reliable bridge between MS Excel and the most popular databases. The Excel Export Kit, software pack exports data from MS Excel files to MS SQL, MySQL, Oracle and PostgreSQL databases.
Excel Export Kit Features:
All versions of Microsoft Excel are supported (including MS Excel 2012).
Migrates MS Excel data to MS SQL Server (all versions of MS SQL are supported including Azure SQL).
Migrates MS Excel data to MySQL (all versions of Linux/Unix and Windows MySQL are supported).
Migrates MS Excel data to Oracle server (all versions of 32- and 64- bit Windows and Linux/Unix Oracle are supported.
Migrates MS Excel data to PostgreSQL server (all versions of PostgreSQL starting from v…
Learn more about Excel Export Kit
You can export your pivot tables to Microsoft® Excel (XLSX). When you export a pivot table to Excel, the data that is exported is the data that is displayed in your widget.
Exporting to Excel maintains your pivot’s layout and structure, and values such as sub-totals, which are not maintained when you export a pivot table to CSV.
Limitations
From Sisense V8.2.1 for Linux deployments, the maximum number of visible columns in pivot tables is set by default to 70.
Your Sisense Administrator can change this default value.
When you upgrade your Linux deployment to Sisense V8.2.1, pivot tables with more than 70 columns will automatically reduce to 70 visible columns, according to an internal algorithm.
This maximum column limitation does not apply when exporting pivot tables to Excel or CSV.
Sisense supports the exporting of pivot tables of up to 1.5 million cells. Attempting to export a higher number of cells might result in a timeout. The following properties of a pivot table increase the probability of reaching a timeout when dealing with very large tables:
Sub totals or Grand totals
Complex formulas in Values
Data Security rules
Widget-level filters
To successfully export pivot tables, split large pivot table with many columns to separate smaller pivot tables.
The maximum number of rows per page is 200 rows
What are the 3 types of software?
--Computers are managed by software. Software may be divided into three categories: system, utility, and application.
What is the difference between download and install?
--The act of "downloading" a file is distinct from "installing" it. Instructions to utilize the downloaded data to modify your computer are "installing" the file. The file does not alter or be updated if installation is not performed.
What is software used for?
--Software is a collection of instructions, data, or computer programs used to run machines and carry out certain activities. It is the antithesis of hardware which refers to a computer external components. A device running programs, scripts, and applications are collectively referred to as "software" in this context.
