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