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

DBConvert for MS Excel and MSSQL is a software designed for conversion spreadsheets from Microsoft Excel to Microsoft SQL Server/ Windows Azure SQL Databases and vice versa. Integrated Data Selector helps you to simplify your tasks of choosing data range in .xls/ .xlsx spreadsheets Automatically or semi-automatically.

You can convert your entire Excel sheets or select definite ranges of data from MS Excel spreadsheet to create several tables in resulted database. DBConvert for Excel and MS SQL is also suitable for database migration between two SQL servers/ Windows Azure SQL Databases or two Excel files.

Product Highlights

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

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