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.
- 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.