sql OpenDataSource查询excel和csv

office 07：

select * from
OpenDataSource('Microsoft.ACE.OLEDB.12.0','Data Source=路径;Extended Properties=EXCEL 12.0')...[sheet1$] ;

select *
from OpenDataSource('Microsoft.ACE.OLEDB.12.0','Text;HDR=Yes;DATABASE=H:\')...[csv名字#csv]

 

office 03：

select * from
OpenDataSource('MICROSOFT.JET.OLEDB.4.0','Data Source=路径;Extended Properties=EXCEL 8.0')...[sheet1$] ;

 select *
 from OpenDataSource('MICROSOFT.JET.OLEDB.4.0','Text;HDR=Yes;DATABASE=H:\')...[csv名字#csv]