Use the Advantage Data Architect export functionality to export a table's data into a new Advantage table, into an existing Advantage table, or into another file format such as MS Excel, HTML, or a comma-delimited text (CSV) file.
To export data from an open table or query:
| 2. | Right-click anywhere on the opened table's grid. |
| 3. | Select the file format in which to export. Available options are: |
| • | Export into a new Advantage table of the same table type as the original (ADT/ADI/ADM, DBF/CDX/FPT, or DBF/NTX/DBT) |
| • | Export into an existing Advantage table of the same table type as the original (ADT/ADI/ADM, DBF/CDX/FPT, or DBF/NTX/DBT) |
| • | Export into another file format, including: |
| • | Comma-Delimited Text (CSV) |
| • | Data Interchange Format (DIF) |
To export data from a table in the Connection Repository:
| 2. | Expand the list of available tables |
| 3. | Right-click on the desired table and select Export. |
| 4. | Select the file format in which to export. Available options are: |
| • | Export into a new Advantage table of the same table type as the original (ADT/ADI/ADM, DBF/CDX/FPT, or DBF/NTX/DBT) |
| • | Export into an existing Advantage table of the same table type as the original (ADT/ADI/ADM, DBF/CDX/FPT, or DBF/NTX/DBT) |
| • | Export into another file format, including: |
| • | Comma-Delimited Text (CSV) |
| • | Data Interchange Format (DIF) |
Exporting data into a new or existing Advantage table will copy the table data and memo data, and it will copy the data in indexed order if an index is active. When exporting into a new Advantage table, a table and memo file (if applicable) will be created, but no index file(s) will be created. When exporting into an existing Advantage table, if the destination table is of a different field structure than the source table, only those columns of the same name will attempted to be exported into the destination table.
