Теми рефератів
> Реферати > Курсові роботи > Звіти з практики > Курсові проекти > Питання та відповіді > Ессе > Доклади > Учбові матеріали > Контрольні роботи > Методички > Лекції > Твори > Підручники > Статті Контакти
Реферати, твори, дипломи, практика » Курсовые проекты » Інструмент OLE

Реферат Інструмент OLE





ny version 1.01. Each field from the table/.DBF becomes a column in the new spreadsheet, and each record in the table/.DBF becomes a row in the spreadsheet.


WRK


A Lotus Symphony spreadsheet can be created from a FoxPro table/.DBF with this option. A. WRK extension is assigned to the spreadsheet file name for use with Symphony version 1.10. Each field from the table/.DBF becomes a column in the new spreadsheet, and each record in the table/.DBF becomes a row in the spreadsheet.


XLS


Include XLS to create a spreadsheet you can use in Microsoft Excel. Each field in the + Selected table/.DBF becomes a column in the spreadsheet; each table/.DBF record becomes a row in the spreadsheet. An. XLS file name extension is assigned to the newly created spreadsheet file unless you specify a different extension.


The format of IMPORT is:

IMPORT FROM

[TYPE]

FW2 | MOD | PDOX | RPD | WK1 | WK3 | WKS | WR1 | WRK | XLS


As it shown in format (TYPE) there are many possible Microsoft applications to import from to FoxPro but the meaning of these properties, description of which you can see in the previous chapter, that's why it's not necessary to list all of them again. So we will mention those most common used. br/>

Remarks


Most software packages store their data in a file format that cannot be opened directly in FoxPro. IMPORT creates a new FoxPro table/.DBF from data stored in file formats that FoxPro cannot read.

A new table/.DBF is created with the same name as the file the data is imported from. A. DBF extension is assigned to the newly created table/.DBF. br/>

Clauses



is the name of the file to import data from. If you don't include an extension with the file name, the default extension for the specified file type is assumed. br/>

TYPE


The key word TYPE is optional, but you must include one of the following file types described below.


PDOX


Include PDOX to import Paradox files. Database files in Paradox versions 3.5 and 4.0 by Borland can be imported by including the PDOX option.


XLS


Include XLS to import data from Microsoft Excel spreadsheets versions 2.0, 3.0 and 4.0. Columns from the spreadsheet become fields in the table/.DBF, and the spreadsheet rows become records in the table/.DBF. Spreadsheet files created in Microsoft Excel have an. XLS extension.


The format of COPY is:


COPY TO

[FIELDS ]

[]

[FOR ]

[WHILE ]

[[WITH] CDX] | [[WITH] PRODUCTION]

[NOOPTIMIZE]

[[TYPE] [FOXPLUS | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1 | WRK | XLS |


Назад | сторінка 3 з 9 | Наступна сторінка





Схожі реферати:

  • Реферат на тему: National features of cuisine and table manners
  • Реферат на тему: Створення на мові програмування Java аплету, реалізуючого інтерфейс Gnumeri ...
  • Реферат на тему: Поняття та використання Network File System
  • Реферат на тему: Опробування знімків Landsat Climate Data Record
  • Реферат на тему: Текстова операційна система Microsoft Word. Microsoft Excel