Access2003和Access2007连接字符串 ：以下分别为使用Access2003和Access2007的连接字符串：  Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XXX.mdb; Provider=Microsoft.ACE.OLEDB.12.0;Data Source=XXX.accdb; sql语句：select ID,T

 select * into 要生成的SQL表名 from OPENROWSET(MICROSOFT.JET.OLEDB.4.0,dBase IV;HDR=NO;IMEX=2;DATABASE=c:/,select * from dbf表名.dbf) --方法二： select * into 要生成的SQL表名 from OPENROWSET(MICROSOFT.JET.OLEDB.