Schema.ini:文本文件驱动程序,感觉叫配置文件可能更合适,
示例:
sql语句:
INSERT INTO Numtab ( Issue, Num ) // 插入特定的行SELECT Issue, NumFROM [TEXT;Database=D:\Test\(存放数据库的路径);table=Flie.txt(文本数据)].Flie.txt;
Test目录下:
Test.mdb
Flie.txt
OtherFlie.txt
Schema.ini的配置:
[Flie.txt]ColNameHeader = trueCharacterSet ...