GATEWAY (Short Name: GAT)
Top  Previous  Next

Use the GATEWAY command to start the Import/Export utility.

IMPORTANT NOTE ABOUT GATEWAY: You MUST be aware of both your source file structure and table structure for the command to function properly. The table and file structure MUST coinside with each other.


gateway

EXPORT

Specifies that you want to export an R:BASE table or view to an external file.

type
Specifies one of the following codes for accepted file formats:

onestep Export type  
 
Code
Details
DBF
DBASE
DB
Paradox
CSV
ASCII File, Delimiter Comma, Qualifier Double Quote
HTM
HTML
XLS
MS Excel Spreadsheet
XLS
MS Excel Workbook
DOC
MS Word
TAB
ASCII File, Delimiter Tab, Qualifier None
SLK
SYLK Symbolic Link
DIF
DIF Data Interchange Format
WK1
Lotus 1_2_3
WQ1
QuattroPro
SQL
SQL Script
XML
XML
CLBR
MS Windows Clipboard
RTF
Rich Text Format
SAV
SPSS Format
PDF
Adobe Acrobat Portable Document Format
LDIF
LDAP Data Interchange Format
 

filename
Specifies the name of the file to import, or the name of the file to export to.

SELECT clause
Specifies and limits rows of data. For more information, see the "SELECT" command.

IMPORT
Specifies that you want to import an external file to an R:BASE table.

type
Specifies one of the following codes for accepted file formats:

onestep Import type  
 
Code
Details
DBF
dBASE
DB
Paradox
TXT
ASCII File, Delimiter None, Qualifier None
CSV
ASCII File, Delimiter Comma, Qualifier Double Quote
QSV
ASCII File, Delimiter Comma, Qualifier Single Quote
ISV
ASCII File, Delimiter Semicolon, Qualifier Single Quote
TAB
ASCII File, Delimiter Tab, Qualifier None
CUS
ASCII File, Delimiter and Qualifier based on DB Settings
XLS
MS Excel
WKS
Lotus 1-2-3
HTM
HTML
WKQ
QuattroPro
XML
XML Format
MDB
MS Access Database
 

filename
Specifies the name of the file to import, or the name of the file to export to.

CREATE
Creates a destination table with the same name as the imported file.

APPEND
Adds the imported data to the end of the table or view specified in tblview.

REPLACE

Replaces the rows in the table or view specified in tblview with the imported data.

tblview
Specifies the name of a table or view FOR Import.

OPTION

Specifies any file format specific options to include:

NOTE: Use pipe | symbol to separate OPTION parameters if more than one option is used  

onestep Import  

MDB (MS Access)  
 
SOURCE_TABLE value  
This property is used for access to data in a specific table of the MDB file  
 
XLS (MS Excel)  
 
SHEET_INDEX value  
This property is used for access to data in a specific sheet of the spreadsheet file  

WKS (Lotus 1-2-3)  
 
SHEET_INDEX value  
This property is used for access to data in a specific sheet of the spreadsheet file  

WKQ (QuattroPro)  
 
SHEET_INDEX value  
This property is used for access to data in a specific sheet of the spreadsheet file  

onestep Export  

DB (Paradox)  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
                             
NOTE: This option allows you to export data as Paradox format using BDE Engine. For use this option, you need to have BDE 32 bit version installed on your computer.  

DBF (dBASE)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: This option allows to export a data as Paradox format using BDE Engine. For use this option, you need to have BDE 32 bit version installed on your computer.  

CSV (Comma Separated Values)  
 
COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
QUALIFIER  
Changing the value of this option you can define any qualifier for fields in the target Comma Separated Values text file.  
 
The popular value is Quotes (") but you can define any custom character you wish.  
 
SEPARATOR  
Defines the separator of fields in target text file.  
 
The popular values are Semicolon (;), Comma (,), Space (#32) but you can define any other character if you wish.  
 
REC_SEP  
Defines the separator between lines in the target text file.  
 
The popular value is CRLF (#13#10) or CR(#13) but you can define any other custom string.  
 
Available Parameters: CR  
LF  
CRLF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

HTM (HTML)  
 
HTML_PATERN  
In this option you can define your own pattern of html_file where you can customize any settings _ fonts, colors, metatags, scripts etc Using this option you can integrate the generated html_file into your own web_site.  
 
By default the HTML Pattern have a simple structure:  
 
<html>  
<head>  
<meta http_equiv="Content_Type"  
content="text/html; charset=windows_1251">  
<meta name="GENERATOR" content="RBG7 Gateway">  
<title>Data Exported by R:BASE 7.1 File Gateway</title>  
</head>  
<body bgcolor="#FFFFFF">  
</body>  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: The generated data table will be inserted before </body> tag.  

XLS (MS Excel Spreadsheet)  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: This option does not use the MS Excel application as OLE_server and is very quick.  

XLS (MS Excel Workbook)  
 
COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
TAB_NAME  
If defined, will be used as the label for the first tab on MS Excel Workbook.  
 
STYLE  
This option adds background color to exported data.  
 
Available Parameters: NORMAL  
PRICELIST  
MSMONEY  
BRICK  
DESERT  
EGGPLANT  
LILAC  
MAPLE  
MARINE  
ROSE  
SPRUCE  
WHEAT  
ZEBRA  
                             
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: Use this option to export data as MS Excel Workbook file using the MS Excel application as OLE_server.  
 
Export process using this type can take a lot of time with large record_sets but you can export a lot of "extended" data. For example STYLE.  
 
If you don't need visual styles in spreadsheet and want to export data only, you can use the XLS option which generates the Excel spreadsheet very quickly.  

DOC (MS Word Document)  

TITLE  
If defined, will be the page header on each page of the document.  
 
COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: This option uses MS Word application OLE_server to export data and create DOC file. To use this option, you need to have MS Word installed on your computer. Export process using this option can take a lot of time with large record_sets.  
 
As a faster method we suggest that you use RTF option.  

TAB (Tab Separated Values)  
 
COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
QUALIFIER  
Changing the value of this option you can define any qualifier for fields in the target Tab Separated Values text file.  
 
The popular value is Quotes (") but you can define any custom character you wish.  
 
SEPARATOR  
Defines the separator of fields in target text file.  
 
The popular values are Semicolon (;), Comma (,), Space (#32), TAB (#9) but you can define any other character if you wish.  
 
REC_SEP  
Defines the separator between lines in the target text file.  
 
The popular value is CRLF (#13#10) or CR(#13) but you can define any other custom string.  
 
Available Parameters: CR  
LF  
CRLF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  
 
SLK (Symbolic Link)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

DIF (Data Interchange Format)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

WK1 (Lotus)  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

WQ1 (QuattroPro)  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

SQL (SQL Script)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: Use this option to generate SQL script with dump of selected table data. Each record will include the INSERT INTO statements which you can execute in any SQL compliant database.  

XML (Extended Markup Language)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: Use this option to generate modern and universal XML format to exchange and transfer data between different sources. You can also view any data exported as XML format in MS Internet Explorer 5.0 (or higher) like a tree.  


CLBR (MS Windows Clipboard)  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

NOTE: Use this option to generate exported data as MS Windows Clipboard Data. ACTION OPENVIEW option will launch MS Clipbook Viewer. Then, you have to use Paste option to view all data. Refer to MS Clipbook Viewer for more details and handling exported data.  

RTF (Rich Text Format)  

TITLE  
If defined, will be the page header on each page of the document.  
 
COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process the some messages are available (with error messages, for example). Otherwise the export will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  

PDF (Adobe Acrobat Portable Document)  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  
 
Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.                 
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process the some messages are available (with error messages, for example). Otherwise the export will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  


LDIF (Data Interchange Format)  

BLANK_IF_ZERO ON - Will export zero values as blank values  
BLANK_IF_ZERO OFF - Will export zero values as zero values  
 
The default: BLANK_IF_ZERO OFF  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  
 
Available Parameters: ON  
OFF  
 
MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  
 
Available Parameters: ON  
OFF  
 
ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  
 
Available Parameters: OPENVIEW  


DIALOG

Opens the File Gateway dialog for manual Import/Export configuration.

About the GATEWAY Command

Use the Import/Export utility to import a file from another program into a new or existing table in an R:BASE database or export data from an R:BASE database into a file that can be imported into another program or R:BASE database.

In R:BASE for Windows, you can import or export the following types of files:

·Import Formats include:  
 
dBase (*.dbf)  
Paradox (*.db)  
Text (*.txt)  
Comma Delimited (*.csv)  
Text Data (*.dat)  
Text Printout (*.prn)  
Tab Delimited (*.tab)  
ASCII (*.asc)  
HTML (*.htm, *.html)  
MS Excel Spreadsheet (*.xls)  
MS Excel Workbook (*.xls)  
Lotus 1-2-3 (*.wk1)  
Lotus 1-2-3 (*.wk2)  
Lotus Symphony (*.wr1)  
QuattroPro (*.wq1)  
XML (*.xml)  
MS Access Database (*.mdb)  

·Export Formats include:  

Paradox (*.db)  
dBase (*.dbf)  
Comma Separated Values (*.csv)  
HTML (*.HTM, *.HTML)  
MS Excel Spreadsheet (*.xls)  
MS Excel Workbook (*.xls)  
MS Word (*.doc)  
Tab Delimited (*.tab)  
SYLK Symbolic Link (*.slk)  
DIF Data Interchange Format (*.dif)  
Lotus 1-2-3 (*.wk1)  
QuattroPro (*.wq1)  
SQL Script (*.sql)  
XML (*.xml)  
MS Windows Clipboard  
Rich Text Format (*.rtf)  
SPSS Format (*.sav)  
Adobe Acrobat Document (*.pdf)  
LDAP Data Interchange Format (*.ldif)  


See also: Command Line Import/Export ( How To > FileGateway)