Tuesday, August 12, 2003
From The Edge: Using GATEWAY Command in R:BASE 7.0 (Part I) Section: File Gateway (Export) Chapter: Running R:BASE Your Way! Platform: R:BASE 7.0 for Windows Build: Release Candidate 2 and Higher
The Next Generation R:BASE 7.0 for Windows File Gateway module contains many powerful features to allow data importing and exporting options.
Using the GATEWAY EXPORT option at the command line, now you can automate the entire task of providing desired data formats to your end-user and/or clients. No more limit on importing (using GATEWAY IMPORT) or exporting (using GATEWAY EXPORT) numerous records into and out of R:BASE 7.0 for Windows database.
Export Format Includes:
Paradox (*.db) dBase (*.dbf) Comma Separated Values (*.csv) HTML (*.htm, *.html) MS Excel Spreadsheet (*.xls) MS Excel Workbook (*.xls) MS Word (*.doc) SYLK Symbolic Link (*.slk) DIF Data Interchange Format (*.dif) Lotus 1-2-3 (*.wk1) Quattro Pro (*.wq1) SQL Script (*.sql) XML (*.xml) MS Windows Clipboard Rich Text Format (*.rtf) SPSS Format (*.sav) Adobe Acrobat Portable Document Format (*.pdf) LDAP Data Interchange, Format (*.ldif)
Import Format Includes:
Paradox (*.db) dBase (*.dbf) 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)
You can access File Gateway module either by clicking on "Open File Gateway to Import/Export Data" icon on the Main Window Toolbar or typing GATEWAY at the R> prompt or in a command file.
For complete details, examples and a PDF version of this document:
From The Edge: http://www.razzak.com/fte (R:BASE 7.0 for Windows)
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
