GET DATA

GET DATA 从 ODBC 和 OLE DB 数据源 (数据库) ， Excel 文件 (发行版 5 或更高版本) 以及文本数据文件中读取数据。

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]

* 对于 Excel 4.0 或更低版本的文件，请使用 GET TRANSLATE。

* * 如果省略子命令，那么为缺省值。

可以从 " 数据库向导" ， " 文本导入向导" 或 " 打开文件 " 对话框 (对于 Excel 文件) 生成 GET DATA 命令的语法。

发布历史

示例

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