OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
use test
insert into OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.2.200;User ID=sa;Password=110').test.dbo.adf--´ò¿ªÔ¶³ÌÊý¾Ý¿â
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [kg$])
--²éѯԶ³ÌÊý¾Ý¿â
select * from OPENDATASOURCE('SQLOLEDB', 'Data Source=·þÎñÆ÷µØÖ·;User ID=Óû§Ãû;Password=ÃÜÂë').test.dbo.adf;
--´ò¿ªsqlÔ¶³ÌÊý¾Ý
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [±í¸ñÃû³Æ$])
select * from Opendatasource('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls')...[±í¸ñÃû³Æ$]
--¿ª´òexcel
select * from
opendatasource('Microsoft.jet.oledb.4.0','data source=Êý¾Ý¿âËùÔÚλÖÃ.mdb;user id=admin;password=;')...[±í¸ñÃû³Æ]
--´ò¿ªaccess
£¨×¢£ºÓÃoffice2007µÄͬѧ °Ñprivider¸ÄΪ'Microsoft.ACE.OLEDB.12.0'£¬2007Óë2003µÄÌṩÆ÷ÊDz»Ò»ÑùµÄ¡£¡£ÌرðÖ÷Ò⣡£¡£¡£©
Ïà¹ØÎĵµ£º
ÔÚaccessÖУ¬updateÓï¾ä²»ÄÜÓÐ×Ó²éѯµÄ£¬Èç²»ÔÊÐíÈçÏÂÓï¾ä³öÏÖ£º
UPDATE tblA SET lngID=
(SELECT lngID from tblB WHERE strName='nihao')
ÕâÑù¾ÍÐèÒªÁíÏë°ì·¨½â¾öÎÊÌâ¡£
½â¾ö·½°¸£º
A¡£
¿ÉÒÔÓÃupdateÁíÍâµÄÓï·¨½â¾ö£º
UPDATE Tab1 a,(Select ID,Name from Tab2) b
SET a.Name = ......
»¨ÁËÁ½¸öÍíÉÏ°ïÅóÓѽ«Ò»¸öasp¿ª·¢µÄÍøÕ¾´ÓACCESSÊý¾Ý¿âתÏòSQL SERVER 2000. ÍøÉϲéÁËЩ×ÊÁÏ£¬¼ÓÉÏ×Ô¼ºµÄ¾Àú£¬×ܽ᣺
1¡¢Ê×ÏÈ¿´asp µÄ³ÌÐòÖÐÊÇ·ñÓÐ on error resume next; Èç¹ûÓÐ,ÏÈ×¢Ê͵ô¡£·ñÔòºÜ¶à´íÎóÎÞ·¨±©Â¶³öÀ´
2¡¢´´½¨SQL SERVER Êý¾Ý±í¡£ ʹÓÃSQL SERVER 2000×Ô´øµÄÊý¾Ýµ¼ÈëÏòµ¼£¬½«ACCESSÊý¾Ý¿âÖеıí½á¹¹£¬ÒÔ¼ ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØн¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
aspÁ¬½Óaccess,³öÏÖ0x80004005,δָ¶¨µÄ´íÎó
aspÀ´Á¬½ÓaccessÊý¾Ý¿â
±¾µØ²âÊÔ·¢ÏÖ,¾²Ì¬Ò³¿ÉÒÔ´ò¿ª.
ºÍÊý¾Ý¿â½¨Á¢Á´½ÓµÄ´úÂëconn.open connstr Ðгö´í,µ«ÊÇÒÔÇ°²âÊÔʪ¿ÉÒÔͨ¹ýµÄ.
ÔÚÍøÉÏÕÒÁËÕÒ½â¾ö°ì·¨,ÀýÈ磺 ¸øÓû§¼ÓȨÏÞ,¸ü¸ÄiisÉèÖÃ.µ«ÊÇ»¹ÊDz»ÐÐ.
¼ÌÐøÕÒ£¬ÕÒµ½Ò»ÆªÎÄÕ£¬ËµÊÇÒªÐÞ¸Äc:\windows\temp ȨÏ޵ġ£
......