Importing and Exporting Data

You can copy data between Visual FoxPro and other applications by importing to and exporting from Visual FoxPro. The data can be in any one of a variety of text, spreadsheet, and table file formats. You can create a new Visual FoxPro table, add to an existing Visual FoxPro table, or copy data to a different file type.

In This Section

Importing and Exporting Concepts

When you import or append data, you bring the data from another application into Visual FoxPro. When you export data, you send data from a Visual FoxPro table to a file type used by another application.

Importing Data

If you want to import from your source file, you can either let Visual FoxPro define the structure of the new table or use the Import Wizard to specify its structure.

Appending Data

You can add your text, spreadsheet, or table data to an existing Visual FoxPro table. By default, Visual FoxPro uses the file type to map the source fields to the destination table.

Exporting Data

You can export data from your Visual FoxPro tables to text files, spreadsheets, or tables used in other applications.

Data Access Management Using CursorAdapters

Describes support for working with different data source types as native Visual FoxPro cursors using CursorAdapter objects.

Converting Between XML and Visual FoxPro Data

Introduces exchanging data more easily with other applications by converting Visual FoxPro data to XML format.

XML Functionality Using XMLAdapters

Discusses the extension of Visual FoxPro's XML features and compatibility with XML DiffGram and .NET Framework ADO.NET DataSet formats and supporting hierarchically formatted XML.

Related Sections

Working with Data

Find out how to create effective applications with indexes, tables, and databases based on your data requirements.

Using Visual FoxPro

Visual FoxPro programming features are designed to improve developer productivity, including Access and Assign methods, support for more graphic file formats, and language to simplify programming tasks.

Developing Visual FoxPro Applications

This section includes conceptual information about how to develop Visual FoxPro applications, instructions for creating databases and the user interface, and other tasks needed to create Visual FoxPro applications.

Programming in Visual FoxPro

Visual FoxPro is a powerful interactive data management tool, but you also can access the full power of Visual FoxPro by creating applications. Understanding object-oriented programming techniques and the event-driven model can maximize your programming productivity.

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic