SQL*XL Features |
|
SQL*XL's main feature is establishing a connection to the database and interact with its data. After a database connection is established you can exchange information between Excel and the database - both imports and exports are supported. Unlike Microsoft's external data utility msquery - SQL*XL goes the extra mile and allows data imports as well:
Connect from Excel to a database
Export: Query data into Excel
Import: Insert Excel data into a database
Update: Send updated data from Excel back to the database
Parameters: Using Excel cells and other parameters in the SQL
See also: