Devart Excel Add-in Database Pack

Work with database data in Microsoft Excel.

Published by Devart
Distributed by ComponentSource since 2005

Prices from: $ 391.95 Version: 2.9.1323 Updated: Feb 27, 2024

Screenshot of Devart Excel Add-in Database Pack

About Devart Excel Add-in Database Pack

Work with database data in Microsoft Excel.

Devart Excel Add-in Database Pack allows you to connect Microsoft Excel to database data. You can quickly and easily load from databases to Excel, instantly refresh data from the database, edit the data, and save it back. It enables you to work with database data like you do with Excel worksheets. You can easily perform data cleansing and de-duplication and apply all Excel's powerful data processing and analysis capabilities to the data.

Features

  • Powerful Data Import - The add-in allows you to precisely configure what data to load into the document. It allows you to select objects, columns and set complex data filters.
  • Quick Data Refresh - The add-in allows you to get the data with a single click, without repeating the whole import operation each time. You can refresh data in your workbook easily whenever you want.
  • Easy Data Modification - You can edit data in Microsoft Excel just like you usually do, add or delete rows, modify cell values, etc. Use the full power of Excel to perform mass data updates, insert, and delete operations against your data source. After you have finished editing, just click Commit and the changes will be posted back to the data source.

Supported Databases

  • Oracle
  • SQL Server
  • MySQL
  • PostgreSQL
  • SQLite
  • DB2