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 Pervasive OLEDB Connection

SQL*XL: Excel Pervasive OLEDB Connection


To connect to Pervasive using the OLE DB Provider (driver) please follow the procedure below:

Start Excel

Open the Connection dialog: SQL*XL | Connect...

Start the Data Link Properties wizard

Data Link Properties

Choose the Provider  Pervasive OLE DB Provider.


Data Source:
Enter the database name. I used sampledata because that is one of the databases that was installed with a trial version  of Pervasive PSQL v10

Enter ther name of your server. I a blank as I am running the database locally. Localhost would have also worked.


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