|
#2
xu20002006-06-27 11:21
“然后在程序中同过运行ADOQuery1.Active :=False;来运行它”
 |
最近在做一个将EXCEL里的数据导入到SQL中。
我用ADOConnection和ADOTable控件连的SQL
然后用的ADOQuery控件。在其属性里SQL中写下如下语句：
SELECT COMPANY, CREATOR, USR_GROUP,CREATE_DATE, MODIFIER, MODI_DATE, FLAG, MB001, MB002, MB003, MB004, MB005, MB006, MB007, MB008, MB009, MB010, MB011, MB012, MB013, MB014, MB015, MB016, MB017, MB018, MB019, MB020, MB021, MB022, MB023, MB024, MB025, MB026, MB027, MB028, MB029, MB030, MB031, MB032, MB033, MB034, MB035, MB036, MB037, MB038, MB039, MB040, MB041, MB042, MB043, MB044, MB045, MB046, MB047, MB048, MB049, MB050, MB051, MB052, MB053, MB054, MB055, MB056 INTO TempASTMB FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=d:\11.xls;Extended Properties=Excel 8.0')...[ASTMB$]
然后在程序中同过运行ADOQuery1.Active :=True;来运行它
可是一但运行起来。就会报错。错误的提示是：ADOQuery1：CommandText does not return a result set
但是在SQL中，数据已经全部插进去了。
请问该怎么解决这个报错的问题？
[此贴子已经被作者于2006-6-27 16:32:42编辑过]