SELECT cast(fields2 as varchar(100)),cast(fields3 as varchar(100)),cast(fields1 as varchar(100))
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions$呢??
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions$呢??
那你以前最后是怎么做的阿?
(可不可以先将xls文件中的内容格式都转成string,再取出)