insert ZHGLG (a,b,c,d) select A,B,D,F from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\报表";User ID=Admin;Password=;Extended properties=dBase 5.0')...ZHGLG