'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source='
+ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...['
+SheetName+'$]';
Èç¹ûÎÒµ ......
ÏÖÔÚÊý¾Ý¿âÖÐÓÐÒ»ÕÅ±í´æÔÚ£¬ÎÒÏëͨ¹ýDelphiÖ´ÐÐÒ»¸öSqlÓï¾ä£¨±ÈÈç¡°select column1 from table1¡±£©£¬ÎÒÔõô²ÅÄܽ«Õâ¸ösqlÓï¾äµÄÖ´Ðнá¹ûдµ½Êý¾Ý¿âÖÐÒ»ÕÅÒѾ´æÔڵıíÖÐÄØ£¿ÕâÖÖ·½·¨¾Í²»ÒªËµÁË£ºÓÃADOQuery²éѯ£¬ÔÙÒ»¸ö¸ö¶ÁÒ»¸ö¸öд£¬ÕâÑùÌ«Âý£¬ÒòΪÊý¾ÝÁ¿ºÜ´ó£¨70WÐУ©¡£
Çë¸ßÊÖÃǸøË¼Â·£ ......
1¡¢Â·¾¶ imgPath:string;//±ÈÈçÒѾµÃµ½ÁËͼƬ·¾¶
2¡¢SQL2000 Êý¾Ý¿â ±íÃû ttbtestimg ×Ö¶ÎÃû img ×Ö¶ÎÀàÐÍimage
3¡¢Çë¸øÒ»¸öÍêÕû´úÂ룬½«´Ë·¾¶ÏµÄͼƬ£¬´æÈëÊý¾Ý¿â£¬ÏàÓ¦±íµÄÏàÓ¦×Ö¶ÎÖÐ
4¡¢Çë¸ø³öÒ»¶ÎÍêÕû´úÂ룬½«´Ë±íÖеÄͼƬÏÔʾÔÚͼƬ¿Ø¼þÉÏ
4¡¢Çë¸ø³ö×¢ÊÍ
5¡¢³ÌÐòÒ»Í ......
ÏÂÃæÊDZ¾ÈËдµÄ´úÂ룺
unit untDepttree;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ComCtrls, StdCtrls, DB, ADODB;
type
TfrmDepttree = class(TForm)
GroupBox1: TGroupBox;
&n ......
¹©Ïà¹ØÈËÔ±²Î¿¼£º
ÔÚDELPHIÖг£³£ÒªÓõ½ADOQUERYÖеÄSQLÓï¾äÔö¼ÓÐÅÏ¢ºóÖ´ÐУ¬µ±ÒªÇóÔö¼ÓÌõ¼þ£¨Èç²ÎÊýʱ£©ÖмäµÄ¼ä¸ôºÜÖØÒª£¬¸ã²»ºÃ¾ÍÒª³ö´í£ºÏ¾ÙÀý˵Ã÷ÎÒÒª±í´ïµÄÒâ˼£º
È磺һ¸ö±í:student ÓÐ ksh,xm,xb,lqzy,lqcc¼¸¸ö×ֶΣ¬¶¼Îª×Ö·ûÐÍ¡£ÏÖÒªÇó°´xb·Ö×éͳ¼ÆÈËÊý£¬Í¬Ê±lqccÒªÇóÏÞ¶¨Ìõ¼þ¡£
Ò»°ãÇé¿öÏ ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóûÓÐÈκα仯£¬
t-sqlÓï¾äÈçÏÂ
insert into table select * from table IN [ODBC] [ODBC;Driver={Micros ......