ACCESSS中查QLSERVER表:SELECT * from [ODBC;Driver=sql server;server=sndcfr;uid=sa;pwd=;database=text].表名
SQLSERVER中查ACCESS表:select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'd:/1.mdb';'admin';'',[表名]) 或者select * from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source="d:/1.mdb";Persist Security Info=false;Jet OLEDB:Database Password=;' )...[aaa]
在SQLSERVER中直接用SQL语句查询EXCEL文件SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="F:/文档方案/通讯录.xls";Extended Properties="Excel 5.0;HDR=Yes;";Persist Security Info=False')...[Sheet1$]
