SQL*XL Advanced Features

SQL*XL home

Advanced Database Connections:

• Using the Data Link Properties wizard
• Using the ODBC Data Source Administrator
• Create A New ODBC Data Source window

• Batch execute Multiple Statements
• Use of non SQL commands
• Explicit Column Formatting
• Rerun a query
• Execute SQL*XL from Excel macros (VBA)
• Calling Procedures and Functions
• Automate the daily insertion of a dbase file into Oracle using SQL*XL
• Migrate data from one database to another database
• Automatically connect to the database

See also:

• Dialogs
• Menu and Toolbar Items
• SQL*XL Home