F FlyDayDream Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-23 #1 select * into [Excel 8.0;database=<d:/bz.xls>].[<AA>$] from bbb 出现提示信息: 不能更新。数据库或对象为只读
L lngdtommy Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-30 #2 //access2excel ADOConnection1.ConnectionString:= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/bz.xls;' +'Extended Properties=excel 8.0;Persist Security Info=False'; ADOConnection2.Execute('SELECT * into aafrom [G:/mysmallexe/excel2sql/Server.MDB;pwd=happynewyear].bbb'); http://www.delphibbs.com/delphibbs/dispq.asp?lid=1691966
//access2excel ADOConnection1.ConnectionString:= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/bz.xls;' +'Extended Properties=excel 8.0;Persist Security Info=False'; ADOConnection2.Execute('SELECT * into aafrom [G:/mysmallexe/excel2sql/Server.MDB;pwd=happynewyear].bbb'); http://www.delphibbs.com/delphibbs/dispq.asp?lid=1691966