GET DATA

GET DATA liest Daten aus ODBC und OLE DB-Datenquellen (Datenbanken), Excel-Dateien (Release 5 oder höher) und Textdatendateien.

GET DATA
  /TYPE = {ODBC }
          {OLEDB}
          {XLS  }
          {XLSX }
          {XLSM }
          {TXT  }


  /FILE = ’filename’


Subcommands for TYPE = ODBC and OLEDB
  /CONNECT=’connection string’
  [{/ENCRYPTED  }]
   {/UNENCRYPTED}
  /SQL ’select statement’
      [’select statement continued’]


Subcommands for TYPE=ODBC, TYPE=OLEDB, XLS, XLSX, and XLSM
 [/ASSUMEDSTRWIDTH={255**}]
                    {n    }


Subcommands for TYPE = XLS, XLSX, and XLSM*
  [/SHEET = {INDEX**} {sheet number}]
            {NAME   } {’sheet name’}
  [/CELLRANGE = {RANGE }  {’start point:end point’ }]
                {FULL**}
  [/READNAMES = {on** }]
                 {off  }
  [/DATATYPEMIN PERCENTAGE=value]
  [/HIDDEN IGNORE=(NO**}]
                  {YES }
  [/LEADINGSPACES IGNORE={NO**}]
                         {YES }
  [/TRAILINGSPACES IGNORE={NO**}]
                          {YES }
  
Subcommands for TYPE = TXT
  [/ENCODING = {'UTF8'   }]
               {'UTF16'  }
               {'UTF16BE'}
               {'UTF16LE'}               
               {'LOCALE' }
  [/ARRANGEMENT = {FIXED      }]
                  {DELIMITED**}
  [/FIRSTCASE = {n}]
  [/DELCASE = {LINE**     }]1
              {VARIABLES n} 
  [/FIXCASE = n]
  [/DELIMITERS = {"delimiters"}]
  [/QUALIFIER = "qualifier"]
  [/IMPORTCASE {ALL**}
               {FIRST n}
  [/DATATYPEMIN PERCENTAGE=value]
  [/LEADINGSPACES IGNORE={NO**}]
                         {YES }
  [/MULTIPLESPACES IGNORE={NO**}]
                          {YES }

VARIABLES subcommand for ARRANGEMENT = DELIMITED
  /VARIABLES = varname  {AUTO  }
                        {format} 

VARIABLES subcommand for ARRANGEMENT = FIXED
  /VARIABLES varname {startcol - endcol} {AUTO | format}
     {/rec#} varname {startcol - endcol} {AUTO | format} 

  [/MAP]

*Verwenden Sie für Excel 4.0 oder frühere Dateien GET TRANSLATE.

* * Standardwert, wenn der Unterbefehl weggelassen wird.

Syntax für den Befehl GET DATA kann über den Datenbankassistenten, den Textimportassistentenoder das Dialogfeld Datei öffnen (für Excel-Dateien) generiert werden.

Releaseverlauf

Beispiel

GET DATA 
   /TYPE=XLS
   /FILE='/PlanningDocs/files10.xls'
   /SHEET=name 'First Quarter'
   /CELLRANGE=full
   /READNAMES=on.