Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Features Connecting

Buy now

Download now

SQL*XL online help

 

SQL*XL: Excel Advantage OLEDB Connection</H2>

SQL*XL: Excel Advantage OLEDB Connection

SQL*XL
home

To connect an Advantage Database using the OLE DB Provider (driver) please follow the procedure below:

Open the Connection dialog: SQL*XL | Connect...
Start the Data Link Properties wizard
 

 
Choose the Provider  Advantage OLE DB Provider.
 

 

 
As data source put in the directory name of your database. This is a so called free table database.
Leave the user name and password blank unless you were given other details to use.
Always use the Test Connection button before you continue
 

After connecting to the database once you can reconnect by selecting the connection from the Connection History list and typing the Password.


See also:

SQL*XL ribbon in Excel