¡¼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"; 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(;)" ¡³Fixed length columns 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 '. ¡¼¡³¡µ¡º¡·¡ó¤jºõ²Å¸¹