 Company
News
Screen Shots |
 |
|
|
Data Import/Export Subroutine
This Data Import/Export subroutine manages the
importing or exporting of data, to or from, an ASCII text file.
It is most useful for interfacing with Microsoft's EXCEL, or other
supplier's spreadsheet utilities. Functions provided include the
opening or creation of input/output files, the read/writing of rows
of data, extracting or populating the next cell of row data, and
the closing of files. A predefined Windows utility may be launched
before importing or after exporting the data.
Fields of data are processed as Delimited Text
Strings and are designated as either alphanumeric or numeric. On
input, text fields are left justified and numeric fields are converted
to a numeric variable with special characters removed. (Commas,
dollar signs, minus signs, etc. are removed). ASCII data types supported
include Tab Delimited, Comma Delimited, Lotus and [/] Delimited.
This is a powerful subroutine that makes it very
easy to export or import data to an application.
Key Benefits
- Easily add Export or Import functions to your applications
- Interface transactions from other 3rd party products
- Numeric data is automatically converted when imported
- The operator can navigate to the directory and the file
to be selected for processing
- Can be processed with or without screen displays so can
be used to service WEB Server requests
|
Key Features
- Load or Dump data from/to a Tab or Comma Delimited ASCII
text file
- Converts numeric ASCII data to a numeric variable
- Folder and Filename of interface files can be defined
by the calling program
- Operator may Browse to select files for processing
- Spreadsheet Utility may be launched automatically before
or after the import/export process
|
Screen Shots
back
| up | next |
