将access导入SQL server 的方法
insert into customer_baseinfo (name,hometel,address1) select * from
OpenRowSet('microsoft.jet.oledb.4.0',';database=d:/123.mdb','select top 5 Title,Phone,Address2 from CDB')
customer_baseinfo为要导入的数据表名,后面跟着的是写入的指定字段
将access导入SQL server 的方法
insert into customer_baseinfo (name,hometel,address1) select * from
OpenRowSet('microsoft.jet.oledb.4.0',';database=d:/123.mdb','select top 5 Title,Phone,Address2 from CDB')
customer_baseinfo为要导入的数据表名,后面跟着的是写入的指定字段