Download PDF - RJS Support Center

Transcript
Chapter 4: Fitting DataImport to
Your Needs
This chapter identifies specific types of problems in extracting data from
input files and how to use DataImport to solve these problems. It is
recommended that you read the chapters titled “Introduction” and
“Tutorial” first to understand the basic operation of the program.
Input and Output
This section discusses how to get your data into DataImport and out to
your spreadsheet, database or analysis program.
Input Files
DataImport works best with Input Files in ASCII text format. If your
data application allows it, save a copy of your data to an ASCII text file
for best results. If this is not possible, look for a printing option in your
data application that will print to a text file, rather than to the printer.
These types of options are usually called “print to disk” or “print to file.”
Microsoft Windows provides a printer driver called “Generic / Text
Only” print driver that will produce a file you can use with DataImport. If
you are familiar with printer drivers, install this driver and connect the
driver to the “FILE:” port. If you still need help creating an ASCII text
Input File, see Appendix C: Getting Data out of Other Applications.
Output Files
DataImport can create output files for most spreadsheet and database
programs including Excel, Lotus 1-2-3, Quattro Pro, Access, Paradox and
dBase compatible applications. The list below shows the types of formats
DataImport can read and write. If you do not see the format you need,
check the README for last-minute format additions.
NOTE Keep in mind that most programs can read earlier versions of
their file formats. In most cases, a file format with a version number equal
to or less than your software version will work, unless you are combining
or appending files. In this case, you must output your data as the same
version as the existing output file. You can also output it as an earlier
version and append it from within the software.
DataImport
Chapter 4: Fitting DataImport to Your Needs • 40