A app2001 Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-25 #2 用ADOQUERY，先将其指象数据库，然后 qry1.text:='INSERT INTO ctable ( unitid,zgName, Sex)' + ' SELECT 单位编号, 姓名,性别 FROM [excel 8.0;database=' + XlsName + '].[sheet1$]'; SQL); qry1.Execsql;
用ADOQUERY，先将其指象数据库，然后 qry1.text:='INSERT INTO ctable ( unitid,zgName, Sex)' + ' SELECT 单位编号, 姓名,性别 FROM [excel 8.0;database=' + XlsName + '].[sheet1$]'; SQL); qry1.Execsql;
A app2001 Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-25 #3 报歉，一下没看到是ASP的贴子，发完才看明白，对于ASP不是很了解，当我没说过吧
A Awen.ZW.Yang Unregistered / Unconfirmed GUEST, unregistred user! 2003-11-25 #4 查询器中执行 select * into NameCode from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:/Guoxin/Book1.xls";User ID=Admin;Password=;Extended properties="Excel 8.0;HDR=YES;"')...Sheet1$
查询器中执行 select * into NameCode from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="D:/Guoxin/Book1.xls";User ID=Admin;Password=;Extended properties="Excel 8.0;HDR=YES;"')...Sheet1$
