- In the Data Link Properties dialog box, click the Provider tab, and then click Microsoft OLE DB Provider for ODBC Drivers.
- Click the Connection tab, and under Specify the source of data, click Use connection string.
- Click Build, and then do one of the following:
If you already have a data source set up for the database you want to connect to, double-click the name of this data source, and then skip ahead to step 10.
If you don't have a data source set up, click the File Data Source tab in the Select Data Source dialog box, and then click New.
- In the Create New Data Source dialog box, click Microsoft Paradox Driver, and then click Next.
- Type an identifying name for the data source, click Next, and then click Finish.
- In the ODBC Paradox Setup dialog box, in the Version box, select the version of Paradox that was used to create your database files.
- If the database files are not in the current folder, clear the Use current directory check box, and then click Select Directory to locate and select the folder.
- If your database requires you to set additional connection parameters, click Options. For information about whether you need to change any of these settings, see the administrator for your database. For information about the option settings, click Help in the ODBC Paradox Setup dialog box.
You now have a data source set up on your computer to connect to your Paradox database. In the future when you connect new PivotTable® lists to this database, you won't have to repeat the setup steps.
- Click OK, and in the Select Data Source dialog box, double-click the name of the new data source you just created.
- Click OK to return to the Data Link Properties dialog box.
- On the Connection tab, under Enter information to log on to the server, do one of the following:
If you want users to enter a login name and password to access the data in the PivotTable list when they open your Web page, type the login name in the User name box and type the password in the Password box.
If you don't want users to have to enter a password, type the login name in the User name box, type the password in the Password box, and select the Allow saving password check box.
If your database does not require a password for access and you don't want users to have to log in, select the Blank password check box, and then select the Allow saving password check box. Leave the User name box blank.
- If you want to verify that the connection you've set up works, click Test Connection.
- Click OK in the Data Link Properties dialog box, and if prompted about saving the password, click Yes.
- In the Property Toolbox, under Use data from, click Data member, and then select the table that contains the data you want to display in the PivotTable list.
You may notice that the Data Link Properties dialog box contains some advanced options for developers. If you're interested in learning about these options, click the Help button in the dialog box, and also see the programming Help for PivotTable lists. For information about displaying this Help, click the Help button in a PivotTable list that you're designing, and see "How to get assistance writing programs and scripts for PivotTable lists."
When you complete the instructions for connecting to your database, the drop areas should appear in the PivotTable list, and the data should be available for display. Click the Field List button on the toolbar in the PivotTable list to display the data fields that you can now drag onto the PivotTable list.
Where Can I Get More Information?
- For comprehensive information about designing PivotTable lists, click the Help button on the toolbar in a PivotTable list that you're designing, and see "About designing and publishing PivotTable lists for the Web."
- For information about using Microsoft Access 2000 to connect to databases, type data sources in the Office Assistant or on the Answer Wizard tab in the Access Help window, and then click Search.
- For information about using Excel to set up data sources, type data sources in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.