H hgdong Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #2 insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="D:/dd.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[zd_all$](Code,name) VALUES ('20', 'Test')
insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="D:/dd.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[zd_all$](Code,name) VALUES ('20', 'Test')
G grasshoper Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #4 楼上的句子是往dd.xls插入记录才对吧？ 应该是query组件来执行一个使用opendatasource的查询来访问xls文件 SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/Finance/account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions 把上面的句子添加进query里去open
楼上的句子是往dd.xls插入记录才对吧？ 应该是query组件来执行一个使用opendatasource的查询来访问xls文件 SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:/Finance/account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions 把上面的句子添加进query里去open
W wgh675 Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #5 这段代码是将dbgrid的数据源设定为excel吧？
H hgdong Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #6 哈哈,看错啦,, Select * Into [Table1] FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=//remoteServer/Shared/xx.xls','Select * from [工作表1$]')
哈哈,看错啦,, Select * Into [Table1] FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=//remoteServer/Shared/xx.xls','Select * from [工作表1$]')
C chyzpc1 Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #7 http://www5.skycn.com/soft/29751.html 试试这个方法 QQ:292044357
H hgdong Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #8 按照上面.把数据读取到ADOquery1后,dbgrid的数据源设定为ADOquery1, ADOquery1+Dbgrid1不就可以显示了...
G grasshoper Unregistered / Unconfirmed GUEST, unregistred user! 2006-10-19 #9 收回我刚才那贴的句子，那句执行有问题，下面这句绝对可执行，测试过了，按楼上所说的方法执行这条句子即可 SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="XLS文件路径";Extended Properties="Excel 8.0";Persist Security Info=False')...[工作表名$]
收回我刚才那贴的句子，那句执行有问题，下面这句绝对可执行，测试过了，按楼上所说的方法执行这条句子即可 SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="XLS文件路径";Extended Properties="Excel 8.0";Persist Security Info=False')...[工作表名$]
J jianlianghu Unregistered / Unconfirmed GUEST, unregistred user! 2006-11-09 #11 把EXCEL 文件别存为*.dbf格式然后可以直接调用了
