GET DATA

GET DATA lee datos de orígenes de datos ODBC y OLE DB (bases de datos), archivos Excel (release 5 o posterior) y archivos de datos de texto.

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]

*Para Excel 4.0 o archivos anteriores, utilice GET TRANSLATE.

* * Valor predeterminado si se omite el submandato.

La sintaxis del mandato GET DATA se puede generar desde el Asistente de base de datos, el Asistente de importación de textoo el diálogo Abrir archivo (para archivos Excel).

Historial del release

Ejemplo

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