•
|
•
|
2
|
3
|
The Choose Data Source box lists the defined data sources for any ODBC drivers that are installed on your computer. From this list, click on the Client or Server DSN for the Pervasive database you wish to access, as shown in the example below.
|
4
|
Click OK. You may be prompted to login to the Pervasive PSQL database. If the database is not secure, leave the User and Password fields empty. Otherwise enter your assigned user name and password.
|
5
|
The Query Wizard opens. Simply follow the wizard to select your options such as which tables to query, how to filter and sort the data, and how you would like Excel to return the Pervasive data to you for your use.
|
2
|
From the Access dialog box, choose Blank Access database as shown below. Click OK. (Note that you may also add Pervasive PSQL tables to an existing Access database.)
|
3
|
Next, the File New Database dialog box opens and asks you to name the new database. Name the database and click Create.
|
4
|
5
|
6
|
The Select Data Source box lists the defined data sources for any ODBC drivers that are installed on your computer. Click the Machine Data Source tab as shown in the next figure.
|
8
|
The Access Link Tables dialog box opens. Click each table that you want to import or link, and then click OK.
|