sqlµ¼accessµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET
´úÂëÕâôдµÄ string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms; int i = rmdc.ExecuteCommand(sqlCmd); È»ºóÌáʾ´íÎó Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ "Data Source=D:\2010-05-20.mdb,pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ °ÑËùÓÐȨÏÞ¶¼½µµ½×îµÍÁË£¬ÓÃaccessÒ²ÄÜÕý³£´ò¿ª£¬Ò²Ã»ÓÐÃÜÂ룬ÒÔǰ×öÀàËÆµÄ¹¦ÄÜÕâôдҲû´í°¡ ²»ÖªµÀÊÇÕ¦»ØÊ°¡ »·¾³vs2008 office2007
Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶÒýÓà ָ¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶ ¸ñʽ,ÊÔÏ SELECT * INTO [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\Êý¾ÝÎļþ.mdb;].main ... Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ¿ìÎÞÓïÁË£¬ºÍ»·¾³ÓйØÏµÃ´ ´úÂëдµÄÕæÄÑ¿´¡£¡£¡£ "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\sourcemachine\test\test.mdb"; ʹÓÃOldbConnectionµ¥¶ÀÁ¬½Ó ±ðÄÇÑùд¡£ ÄÇÀïÄÑ¿´ÁË£¬¾ÍÒ»¸öÖ±½ÓдÈ룬ºÎ±ØÓÃoledbµ¥¶ÀÁ¬½Ó µ¥¶ÀÁ¬½ÓµÃ°ÑÊý¾ÝÈ¡³öÀ´ÔÙдÈë°É£¬ÄÜÖ±½Ó¿
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
´úÂëÈçÏ Çë¸ßÊÖ Ö¸µãÏ лл ajax_http.js ------------- function getXMLHTTP() { var xmlhttp; if (window.ActiveXObject) { //IE try { ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º DECLARE @STR NVARCHAR(MAX) SET @STR='SELECT * from SALE_PROD' ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿ Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡ ¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡ Ö±½ÓÖ´ÐоÍÐÐÁË exec ......