Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL help
First Use
Features
Advanced
Commands
Dialogs
Menu & Toolbar
Excel Functions
Trouble Shooting
VBA & Macros
SQL*XL
Key Features
Usage
Editions
Customers
Forums
Help
Links
Download
Order
SQL*XL: Database to Excel bridge
litLIB: Excel power functions pack
encOffice: Protect your Excel file easy and safe
Home Products SQL*XL Help Features

Buy now

Download now

SQL*XL online help

 

SQL*XL: Features

SQL*XL Features

SQL*XL
home

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:

SQL*XL ribbon in Excel

Copyright (C) 1995-2007 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap