打開Access2000的一個表1. select * from OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0','Data Source=e:\north.mdb;User ID=Admin;Password=')...supply 2. select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'e:\north.mdb';'admin';'',supply)3. select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'e:\north.mdb';'admin';'','select * from supply where 供應商編號>10')導入的話加工一點就可以了 如﹕ select * into tab from openrowset('Microsoft.Jet.OLEDB.4.0', 'e:\north.mdb';'admin';'','select * from supply where 供應商編號>10')
在SQL的数据库中点右键,所有任务--》导入数据;然后怎么做呀?
hdhai9451(※★開拓者...糊涂中☆※ select * from OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0','Data Source=e:\north.mdb;User ID=Admin;Password=')...supply 就行了
INSERT INTO opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source="e:\db1.mdb";Jet OLEDB:Database Password=')...w(aa,bb,cc) SELECT a,b,c FROM aa
'e:\north.mdb';'admin';'',supply)3. select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'e:\north.mdb';'admin';'','select * from supply where 供應商編號>10')導入的話加工一點就可以了
如﹕
select * into tab from openrowset('Microsoft.Jet.OLEDB.4.0',
'e:\north.mdb';'admin';'','select * from supply where 供應商編號>10')
select * from OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0','Data Source=e:\north.mdb;User ID=Admin;Password=')...supply
就行了
SELECT a,b,c
FROM aa