ACCESS¶ÁÈ¡µÄÎÊÌâ

/*
Ò»¡¢SQLServerºÍAccess

1¡¢²éѯAccessÖÐÊý¾ÝµÄ·½·¨£º

select * from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')

»òselect * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\DB2.mdb";User ID=Admin;Password=')...serv_user

2¡¢´ÓSQLServerÏòAccessдÊý¾Ý£º

insert into OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from Accee±í')
select * from SQLServer±í

»òÓÃBCP:master..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" out "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'

ÉÏÃæµÄÇø±ðÖ÷ÒªÊÇ£ºOpenRowSetÐèÒªmdbºÍ±í´æÔÚ£¬BCP»áÔÚ²»´æÔÚµÄʱºòÉú³É¸Ãmdb

3¡¢´ÓAccessÏòSQLServerдÊý¾Ý£º

ÓÐÁËÉÏÃæµÄ»ù´¡£¬Õâ¸ö¾ÍºÜ¼òµ¥ÁË

insert into SQLServer±í select * from
OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from Accee±í')

»òÓÃBCP

master..xp_cmdshell'bcp "serv-htjs.dbo.serv_user" in "c:\db3.mdb" -c -q -S"." -U"sa" -P"sa"'

4¡¢É¾³ýAccessÊý¾Ý£º

delete from OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\db2.mdb','select * from serv_user')
where lock=0