Devart Excel Add-in for SQL Server 관련 정보

Microsoft Excel 내 SQL Server 데이터와 작업합니다.

Devart Excel Add-in for SQL Server allows you to connect Microsoft Excel to SQL Server data. You can quickly and easily load from SQL Server to Excel, instantly refresh data from the database, edit the data, and save it back. It enables you to work with SQL Server 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.