导入和导出工具(DTS)
或:
SELECT * into newdb..新表
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable
或:
SELECT * into newdb..新表
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Finance\account.mdb";User ID=Admin;Password=')...YourTable