请问能否用一条SQL将SQL SERVER中的表数据导入到ACCESS中?

刚刚诸位大虾说了从ACCESS导数据到SQL SERVER,那么相反的SQL是否有呢?
多谢多谢
---------------------------------------------------------------

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus