|
|
Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;
|
|
|
|
|
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties="text;HDR=Yes;FMT=Delimited";
|
|
The delimiter can be specified in the registry at the following location: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text "Format" = "TabDelimited" or "Format" = "Delimited(;)"
|
注意:如果文本文件是Unicode編碼,則需指定CharacterSet為UniCode |
|
|
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties="text;HDR=Yes;FMT=Fixed";
|
|
"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) " or maybe use a single quota '. |
|
|
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. |
|
[customers.txt] Format=TabDelimited ColNameHeader=True 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
|
|