Share via


Import Dialog Box

Lets you import data to a Visual FoxPro table from a spreadsheet or another table format. You can also use the Import Wizard to import files.

Note

You cannot import text files with this menu command. To import text files, use the Import Wizard, or create a table and then append the text file to the new table.

This dialog box appears when you select Import from the File menu.

  • Type
    Specifies the type of file to import. Select a file type from the list.

  • From
    Specifies the path and name of the source file. Type the path and name, or click the dialog button to find the source file.

  • Sheet
    Specifies a Microsoft Excel worksheet to import. This box appears only if you select Microsoft Excel in the Type box.

  • To
    Displays the path, as defined in the File Locations tab, Options dialog box, and the file name of the imported file. The file name is that of the source file, but with a .dbf extension.

  • Import Wizard
    Starts the Import Wizard, which prompts you with simple questions as you go through a brief series of steps. You must use the Import Wizard to import text files, or create a table and then append the text file to the new table.

The following table shows the file types you can import with this command, and their equivalents that you would type in the Command window.

File Types

Command Equivalent

FrameWork II (FW2)

IMPORT FROM FileName TYPE FW2

Lotus 1-2-3 1-A (WKS)

IMPORT FROM FileName TYPE WKS

Lotus 1-2-3 2.x (WK1)

IMPORT FROM FileName TYPE WK1

Lotus 1-2-3 3.x (WK3)

IMPORT FROM FileName TYPE WK3

Microsoft Excel 2.0, 3.0, and 4.0 (XLS)

IMPORT FROM FileName TYPE XLS

MultiPlan 4.01 (MOD)

IMPORT FROM FileName TYPE MOD

Paradox 3.5, 4.0, 4.5 (DB)

IMPORT FROM FileName TYPE PDOX

RapidFile (RPD)

IMPORT FROM FileName TYPE RPD

Symphony 1.01 (WRK)

IMPORT FROM FileName TYPE WRK

Symphony 1.10 (WR1)

IMPORT FROM FileName TYPE WR1

See Also

Reference

Append From Dialog Box

Command Window (Visual FoxPro)

Export Dialog Box

Import Wizard

IMPORT Command

File Locations Tab, Options Dialog Box

Other Resources

Dialog Boxes (Visual FoxPro)

Importing and Exporting Data