Accessing a Visual FoxPro Data Source from Microsoft Excel

  • Article

If you have Microsoft Query installed, you can create a data source in Microsoft Excel that connects to Visual FoxPro data.

To access Visual FoxPro data from Microsoft Excel

  1. Open a Microsoft Excel spreadsheet.

  2. From the Data menu, choose Get External Data. Microsoft Query opens.

  3. In the Select Data Source dialog box, click Other.

  4. In the ODBC Data Sources dialog box, click New.

  5. In the Add Data Source dialog box, select Microsoft Visual FoxPro Driver from the Installed ODBC Drivers list box and click OK.

  6. In the ODBC Visual FoxPro Setup dialog box, enter the data source name, select the Database type, enter the path to the database or directory, and click OK.

    The new data source name is displayed in the Enter Data Source text box of the ODBC Data Sources dialog box.

  7. Click OK.

    The new data source name is selected in the Available Data Sources text box of the Select Data Source dialog box.

  8. Click Use.

You can now add tables to the open query. For more information about building a query, see Importing Data into Microsoft Excel from a Visual FoxPro Database.