Skip to content

importing-data-into-microsoft-excel-from-a-visual-foxpro-database.md

Latest commit

 

History

History
38 lines (30 loc) · 1.87 KB

importing-data-into-microsoft-excel-from-a-visual-foxpro-database.md

File metadata and controls

38 lines (30 loc) · 1.87 KB
title Importing Data into Microsoft Excel from a Visual FoxPro Database | Microsoft Docs
ms.custom
ms.date 01/19/2017
ms.prod sql
ms.prod_service connectivity
ms.reviewer
ms.technology connectivity
ms.topic conceptual
helpviewer_keywords
importing data [ODBC]
FoxPro ODBC driver [ODBC], Excel
Visual FoxPro data [ODBC], Excel
Visual FoxPro data [ODBC], importing
Visual FoxPro ODBC driver [ODBC], Excel
ms.assetid 3085bc4c-00a7-40e5-bffb-c3962cd3d509
author David-Engel
ms.author v-daenge

Importing Data into Microsoft Excel from a Visual FoxPro Database

You can import Visual FoxPro data into your Microsoft Excel worksheet if you have defined a data source for it. For information about creating a Visual FoxPro data source, see Accessing a Visual FoxPro Data Source from Microsoft Excel.

To import Visual FoxPro data into an Microsoft Excel worksheet

  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, select a Visual FoxPro data source and then click Use.

  4. If the database accessed by your data source includes tables, select a table from the Add Tables dialog box. Microsoft Query displays the added table in the top half of the query designer.

    [!NOTE]
    The Owner list is not available in this dialog box because the driver does not support owners. The Database list is not available because the driver does not support multiple databases in a data source.

  5. Select fields for your query by dragging them from the table onto the lower half of the designer.

  6. Close Microsoft Query. The data you selected is imported into your Microsoft Excel spreadsheet.