ms excelms sql

MS Excel to MS SQL Migration

Read here trial versions limitations

Product highlights

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

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)
MS Excel MS SQL

Converter from
MS Excel to MS SQL

  • 23 Sep, 2013
  • Version 1.3.8
ORDER From $ 149 DOWNLOAD 17.16 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MS SQL to MS Excel

New Features

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

Screenshots

Database conversion / synchronization features

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions