Unidac连接Excel文件
终于找到一个连接字符串,记录一下
(图片来源网络,侵删)
UniConnection1.ConnectString := Format('Provider Name=ODBC;Server="DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb); DBQ=%s"', [FileName]);
UniConnection1.connected:=true;
UniConnection1.gettablenames(memo1.lines,false,false);
'select * from ['+memo1.lines.strings[i]+']'
文章版权声明:除非注明,否则均为主机测评原创文章,转载或复制请以超链接形式并注明出处。