ACC97: How to Use Visual FoxPro DBC Files in Microsoft Access

 Last reviewed: February 3, 1998
Article ID: Q176568
The information in this article applies to:
  • Microsoft Access 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

You can use data from a Microsoft Visual FoxPro database in Microsoft Access 97 if you have added a Visual FoxPro ODBC data source as a User Data Source in the ODBC Data Source Administrator. This article describes how to do so.

You can download the latest Microsoft Visual FoxPro ODBC driver from Microsoft's World Wide Web site at: 

   http://www.microsoft.com/vfoxpro/download/
NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address: 

   http://www.microsoft.com/
The article is divided into two parts: the first part explains how to set up the data source for Visual FoxPro, and the second part explains how to link tables in Visual FoxPro.

NOTE: If you use the ISAM driver for Microsoft Foxpro, you are only able to import the data from a DBC file; you are not able to link the DBC files.

MORE INFORMATION

Creating the Data Source in Control Panel

  1. On the Start menu, point to Settings, and then click Control Panel.

  2. In Control Panel, double-click the 32-Bit ODBC icon.

  3. In the ODBC Data Source Administrator box, click the User DSN tab, and then click Add.

  4. In the Create New Data Source dialog box, select the Visual FoxPro driver, and then click Finish.

  5. In the ODBC Visual FoxPro Setup dialog box, in the Data Source Name box, type a name for your data source.

  6. In the Description box, type a description. For the Database type option, select Visual FoxPro database (DBC). In the Path box, type the path to your Visual FoxPro database or click Browse to locate the file. Click OK.

    The data source is created.

Linking a Visual FoxPro table in Microsoft Access 97

To link a Visual FoxPro table from a Microsoft Access database, follow these steps:

  1. Open the sample database Northwind.mdb in Microsoft Access 97.

  2. On the File menu, point to Get External Data, and then click Link Tables.

  3. In the Link box, in the Files Of Type list box, select ODBC Databases().

  4. In the Select Data Source box, on the File Data Source tab, select Visual FoxPro.

  5. In the Configure Connection box, select Visual FoxPro database (.DBC), type or select the path to the file, and then click OK.

    The link to the table is now created.

Additional query words: inf
Keywords : IntpOthr
Version : WINDOWS:97
Platform : WINDOWS
Hardware : x86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.