将EXCEL批量导入至ACCESS中一段源码 有错误 请大吓们看看 在线等你的佳音                       adoquery1.close;
                 adoquery1.SQL.Clear;
                  ssql:= 'insert into kcbiao(字段名)'+                   'select'+'字段名'+                      'from [excel8.0;database='+xls的文件+'].[prdt$]';
                    adoquery1.Parameters.Clear;
                  adoquery1.ParamCheck:=false;
                adoquery1.sql.text:=ssql;
              adoquery1.ExecSQL;