Microsoft Excel to Microsoft SQL Server Migration.

 DBConvert for Excel & MSSQL

Version: 1.4.1

Release Date: Sept. 12, 2015

Conversion directions:

  • Excel → MS SQL Server, MS SQL Dump
  • MS SQL Server → Excel, MS SQL Dump
  • Excel ↔ Amazon RDS

Our DBConvert for MS Excel and MSSQL is an application designed for converting Microsoft Excel spreadsheets into Microsoft SQL Server/ Windows Azure SQL Databases and vice versa. The Integrated Data Selector helps you to simplify your tasks of choosing data ranges in .xls/.xlsx spreadsheets (semi-)automatically.

You can convert your entire Excel workbook or select discrete ranges of data from a MS Excel spreadsheet in order to create several tables in new or existing database. DBConvert for Excel and MS SQL is also suitable for database migration between two SQL servers/Windows Azure SQL Databases or even two Excel files.

Product Highlights

  • Ability to create tables from MS Excel file with Integrated Data Selector
  • Microsoft Excel 2000 or higher 2003/2007/2010
  • Speed conversion with Bulk and Quantization features
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • MS SQL schemes support
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • MS SQL Server (Express) 2000/2005/2008/2008 R2/2012/2014, SQL Azure support
  • Amazon RDS SQL Server DB Instance support

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database Excel resides
  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • Microsoft Visual C++ 2008 x86 Redistributable package

Latest News

  • Speed improvement for better conversion allows converting large databases with nearly 500 thousand records in 30-40 min.
  • Variable quantization step added