ODBC |
Standard
Driver=
{Microsoft Text Driver (*.txt; *.csv)};
Dbq=
c:/txtFilesFolder/;
Extensions=
asc,csv,tab,txt;
|
OLE DB |
Delimited columns
Provider=
Microsoft.Jet.OLEDB.4.0;
Data Source=
c:/txtFilesFolder/;
Extended Properties=
"text;HDR=Yes;FMT=Delimited";
|
(
HDR 表示有无标题行,详细的配置信息在Schema.ini文件中设置
注意引号在不同语言中需要转义,如xml中为"
原文解释: "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite. To specify each columns length use the Schema.ini file. See description below. Important note! The quota " in the string needs to be escaped using your language specific escape syntax. c#, c++ /" VB6, VBScript "" xml (web.config etc) & quot; or maybe use a single quota '. |
Schema.ini |
Schema.ini
[customers.txt] Format=TabDelimited ColNameHeader=Truev MaxScanRows=0 CharacterSet=ANSI [orders.txt] Format=Delimited(;) ColNameHeader=True MaxScanRows=0 CharacterSet=ANSI [invoices.txt] Format=FixedLength ColNameHeader=False Col1=FieldName1 Integer Width 15 Col2=FieldName2 Date Width 15 Col3=FieldName3 Char Width 40 Col4=FieldName4 Float Width 20 CharacterSet=ANSI |
(
schema.ini文件一般和text文件放在同一级目录下,并且文件名必须为schema.ini
原文解释: The schema information file tells the driver about the format of the text files. The file is always located in the same folder as the text files and must be named schema.ini. |