License:
Demo
Price:
145.00
Information:
This tool provides a bridge between Excel and external databases. It supports Oracle connections as native and requires the SQL*XL ADO software to connect to other database types.
SQL is taken from a dialog box, spreadsheet or file. The data is put in the spreadsheet anywhere you want. A spreadsheet full of data can be inserted with a single click. When constraints are violated you are prompted with a database error message. Transaction control lets you rollback or commit the changes.
Once data is fetched into Excel, this program lets you to edit it in the spreadsheet.
|
|
|
