schema.ini(ODBC Text Driver) 的问题

可以通过 ODBC Text Driver 读取 tab 分割的文本文件，
按文档说明（http://msdn.microsoft.com/en-us/library/ms974559.aspx），对于 tab 分割格式需要建立 schema.ini 来提供文件格式信息，
但是在我的测试无法正确识别：每行数据当作一个字段来读取，而不是4个字段！

以下代码，只要将注册表中的默认配置 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\Format 修改为 TabDelimited 就可以分别读取4个字段。

还有需要哪个地方配置？

        static void Main(string[] args)

        {

            /*

             * 1. Issuse

             * Let's say I have 4 fields delimited by tab in each line in the tab-delimited.txt file. 

             * I also have a schema.ini file in the same folder to indicate the format of the tab-delimited.txt file.

             * But it seems the schema.ini file does not override the setting in the system registry(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\Format). 

             * The text engines can not recognize tab as the delimiter. So it still reads the four fields together into one field.

             * 

             * 2. Solution But Tedious

             * Config the default format from CSVDelimited to TabDelimited in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\Format, you will get the expected result.

             */

            string dataSourcePath = Environment.CurrentDirectory + "\\";

            string dataFileName = "tab-delimited.txt";

            string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dataSourcePath + @";Extended Properties=""text;HDR=NO;FMT=TabDelimited""";

            OleDbConnection conn = new OleDbConnection(connString);

            OleDbCommand cmd = conn.CreateCommand();

            cmd.CommandText = String.Format("SELECT * FROM [{0}]", dataFileName);

            DataTable dt = new DataTable(Path.GetFileNameWithoutExtension(dataFileName));

            OleDbDataAdapter da = new OleDbDataAdapter(cmd);

            da.Fill(dt);



            // output as xml.

            dt.WriteXml(dataFileName + ".xml");

            // output into current console.

            Console.WriteLine("The imported data has {0} column(s):", dt.Columns.Count);            

            foreach (DataColumn col in dt.Columns)

            {

                Console.Write(col.ColumnName);

                Console.Write("\t");

            }

            Console.WriteLine();



            foreach (DataRow row in dt.Rows)

            {

                foreach (DataColumn col in dt.Columns)

                {

                    Console.Write(row[col]);

                    Console.Write("\t");

                }

                Console.WriteLine();

            }

            Console.WriteLine();

            //

            Console.Read();

        }

完整测试代码以及样本文件下载：
http://www.cnblogs.com/Files/Jinglecat/ReadSeparatedValuesTest.rar