Excel to SQL Server Migration.

 DBConvert for Excel & MSSQL

Version: 1.4.1

Release Date: Feb. 21, 2018

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

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

Product Requirements

  • Microsoft Visual C++ 2008 x86 Redistributable package
  • 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)

Latest News

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