Microsoft Excel to Microsoft SQL Server Migration.

 DBConvert for Excel & MSSQL

Version: 1.4.1

Release Date: Dec. 23, 2014

Conversion directions:

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

Interface languages

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

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

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

Product Requirements

  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database Excel resides
  • Microsoft Visual C++ 2008 x86 Redistributable package
  • MDAC 2.8
  • 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)

Latest News

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