MDAC 2.5 SDK - Visual FoxPro ODBC Driver

Adding a Visual FoxPro Data Source

To access Visual FoxPro data from your application, you must have a data source. You can create a data source as follows:

• Within an application, such as Microsoft® Word, Microsoft Excel, or Microsoft Access, that uses ODBC drivers.
  
  
• Outside of your application, using the Microsoft Windows® 95, Microsoft Windows 98, or Microsoft Windows NT®/Windows 2000 Control Panel.

Once a data source exists on your system, you can reuse the same data source each time you want to access Visual FoxPro data. If you have several different databases or tables you want to access, you can create a separate data source for each database or directory.

The following procedure creates a data source using the Control Panel. For more information on creating a data source from an application, see Accessing Visual FoxPro Data from Microsoft Office.

To add a Visual FoxPro data source

1. On computers running Windows 2000, open the Windows Control Panel and double-click Administrative Tools.
   
   
2. Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator dialog box. This icon is available after you've installed the Visual FoxPro ODBC Driver or any ODBC driver software.

   Note   If you are running a previous version of Windows, open the Windows Control Panel and double-click 32-bit ODBC or ODBC to open the ODBC Data Source Administrator dialog box.

3. Click Add.
   
   
4. In the Create New Data Source dialog box, select Microsoft Visual FoxPro Driver and then click Finish.
   
   
5. In the ODBC Visual FoxPro Setup dialog box, type the data source name and description, select the database type, select the database or directory, and click OK.

   The new data source name is displayed in the User Data Sources list in the User DSN tab of the ODBC Data Source Administrator dialog box.

6. Click OK to save the new data source and close the ODBC Data Source Administrator dialog box.