using OPENROWSET Select Access Data Base Data

ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
-- OPENROWSET ACCESS ²»ÄÜÓÐÃÜÂë, ÓÐÃÜÂëÓÃOPENDATASOURCE
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb'; /*Access Êý¾Ý¿â·¾¶*/
'admin'; /*Access¹¤×÷×éÃÜÂë*/
'',/*Access¹¤×÷×éÃÜÂë*/
[AccessTableName])
1. ²éѯAccess ±íÄÚËùÓÐÊý¾Ý
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb';
'admin';
'',
[AccessTableName])
2. ²éѯAccess ±íÄÚ [ID] ÔÚ10 µ½ 20 µÄËùÓÐÊý¾Ý
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb';
'admin';
'',
[AccessTableName])
where [ID] BETWEEN 10 AND 20
3. ²éѯAccess ±íÄÚËùÓÐÊý¾Ý, ²¢½«±í(±í½á¹¹ºÍÊý¾Ý)±£´æµ½SQL Server ±íAÄÚ(SQL Server ÄÚ ²»´æÔÚ±íA)
SELECT *
into C
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb';
'admin';
'',
[AccessTableName])
4. ²éѯAccess ±íÍ·, ²¢½«±í±£´æµ½SQL Server ±íDÄÚ(SQL Server ÄÚ ²»´æÔÚ±íD)
SELECT top(0)*
into D
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb';
'admin';
'',
[AccessTableName])
5. ²éѯAccess ±íÄÚ [ID] ÔÚ10 µ½ 20 µÄËùÓÐÊý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server ±íDÄÚ(SQL Server ´æÔÚ±íD)
insert into D
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb';
'admin';
'',
[AccessTableName])
where [ID] BETWEEN 10 AND 20