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.