如何从Sql Server导出数据到Excel/Access?我已经实现(Access->excel,excel->sql server)(纯SQL语句实现)
Access ==> Excel OK
SELECT top 100 INTO [products] in "c:\test.xls" "excel 8.0;" FROM Products
Excel ==> SQL Server OK
select b.* into tbl1 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="C:\1.xls";Extended Properties="Excel 5.0;HDR=Yes;";Persist Security Info=False')...Sheet1$ as b
可是,如何从Sql Server导出数据到Excel/Access?
难道要我建一个MDB,然后在MDB里面写(Access例子,Excel相似):
SELECT * into tbl1 FROM Products IN [ODBC][ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=Demo;]