try:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
where isdate(日期列) = 1
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
where isdate(日期列) = 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货