DataLoad

Author:

• ZIP file containing the DOS and NT/95 versions along with a readme file.
• zipped NT/95 version with readme.
• zipped DOS only version with readme.

As part of my work on the Genstat statistics package I've written a program to read data from a wide range of file formats. As a Gauss user I've tacked on the ability to write numeric data from these files to Gauss PC FMT files (Dos v89 matrix format). I have two copies of this program, a DOS only version which will handle about 12000 items from a spreadsheet (more for other file types), and a NT/95 version which will handle 2,000,000 data items. They will need to be renamed to dataload.exe to run.

Program Specs

DataLoad - Translates Spreadsheet/Database files into Genstat/Gauss format.

Copyright D. Baird, AgResearch, PO Box 60, Lincoln, New Zealand 1998.

Supported File Types: Excel 2-5,95,97, Lotus WK1, Quattro WQ1,WB*, dBase 2-5, Paradox 3-5, Genstat GSH, SAS PC 6.03-11, Minitab 8-11, Systat, MStat, Instat, Epi-Info, Gauss Data/Matrix (PC/Win/Unix), MatLab, S+ (PC/Unix/Text).

Usage: DataLoad Inputfile Outputfile  
   Inputfile  - name of file to take data from.
   Outputfile - name of file to write data to - extension determines
file type:
                .GSH - Genstat spreadsheet file loaded with SPLOAD
                .GEN - Genstat command file loaded with INPUT
                .FMT - Gauss PC Matrix file loaded with LOADM
                .TXT - ASCII Text file
   Sheet      - optional name of worksheet or named range within a
                spreadsheet file to take data from (enclose names
containing
                spaces in quotes eg "Sheet One").
   Range      - optional range of cells within a worksheet to take data
from
                eg B3:D12 or AB2:AZ1201.

Examples: DataLoad Test.DBF Test.FMT
          DataLoad Test.XLS Test.FMT Sheet2
          DataLoad Test.WB2 Test.FMT "Sheet One" B2:AA1001
          DataLoad Test.XLS Test.FMT DataRange    (a named Range in
Excel)