»ñÈ¡accessÊý¾Ý¿â¿ÉѹËõ´óСÎÊÌâ - VC/MFC / Êý¾Ý¿â
ͨ¹ýADO²Ù×÷accessÊý¾Ý¿â£¬ÓÉÓÚÊý¾Ý²Ù×÷ÒÔ¼°»º´æÔÒò£¬Êý¾Ý¿âÎļþ»áÔ½À´Ô½´ó¡£ÕâʱºòÎÒÃǾͻáͨ¹ýѹËõaccessÊý¾Ý¿âÀ´½â¾ö£¬µ«ÊÇÈç¹ûÿ´ÎÔËÐÐÊý¾Ý¿âµÄʱºò£¬¶¼Ñ¹ËõÒ»±é£¬ÄÇÖØ¸´¹¤×÷Ò²¶àÁ˵ã°É£¬ÎÒÏë¡£ËùÒÔÎÒÏëÄܲ»ÄÜͨ¹ýÅжÏaccessÊý¾Ý¿â¿ÉѹËõ¿Õ¼ä´óСÀ´Ñ¡ÔñʲôʱºòѹËõÄØ£¿²»¹ýÓÉÓÚÎÒÄÜÁ¦²»×ã°¡£¬Ã»ÄÜÏëµ½ºÃµÄ°ì·¨£¬Çë½ÌÏ´ó¼Ò£¬Ñ§Ï°Ï¡£
½áÌùÌáÐÑ
Èç¹ûÄúµÄÎÊÌâÒѾµÃµ½½â¾ö£¬ÇëÄúÔçÈÕ½áÌù£¬ÈçËÄÈÕºóδ½áÌù£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÄúµÄÎÊÌâÉÐδµÃµ½½â¾ö£¬Çë»Ø¸´·½±ãÆäËûÍøÓÑÖªµÀÄãÈÔ¹Ø×¢¸ÃÎÊÌâ¡£ÈçËÄÈÕºóûÓÐÆäËûÍøÓѺÍÂ¥Ö÷±¾È˻ظ´£¬¸ÃÌù½«×öÇ¿ÖÆ½áÌù´¦Àí¡£
Èç¹ûÌù×ÓÖ»ÓÐÂ¥Ö÷ºÍÇ¿ÖÆ½áÌùµÄ°æÖ÷±¾È˻ظ´£¬½«°´ÎÞÂúÒâ½áÌû´¦Àí¡£
×¢£ºÇ¿ÖƽáÌù°æÖ÷±¾È˽«²»»á·ÖÅä´ðÌâ·Ö
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÔõÑùʵÏÖµã»÷Ò»¸ö°´Å¥£¬¾Í½«µ±Ç°´°ÌåÖ¸¶¨ÊäÈë¿òÀïµÄÊý¾Ý¸´ÖƵ½Windows¼ôÇаåÄØ£¿ÎÒÊÔ¹ýÓÃClipboard£¬µ«²»ÐУ¬ËƺõûÓÐÕâ¸öº¯Êý
ÓÐÕâ¸ö¹¦Äܰ¡¡£²éÒ»ÏÂmsdn¾Í¿ÉÒÔÁ˰¡¡£
Private Sub mnuCopy_Click ()
Cli ......
VB.NET code:
Public Class excelAccess
Public Function exceltoTb(ByVal strExcelFileName As String, ByVal strSheetName As String) As System.Data.DataTable
Dim cnnStr As String = " ......
ÓÃVB³ÌÐòÖн«excelµÄÎļþ·ÅÔں͹¤³Ìͬһ¸öÎļþ¼ÐÖУ¬µ¼ÈëʱûÓдíÎ󣬵«ÔÚ±ðµÄĿ¼Ïµ¼Èë¾Í»á³öÏÖ´íÎó
Ìáʾ£º Ö÷¹Ø¼ü×ÖÖØ¸´£¨Õâ¸öÅжÏÎÒÔÚ³ÌÐòÖмÓÁË£¬ÔÚºÍACCESSͬһĿ¼ÏÂʱû³öÏÖ´íÎó£©
Common ......
ÎÒÏë´ÓAccess µ¼³öÊý¾Ýµ½DB2£¬ ±ÈÈç˵Access±íÖÐÓÐ3ÌõÊý¾Ý£¬ÎÒÒªµ¼ÈëDB2£¬²¢ÇÒҪɾ³ý¡£ µ«ÊDzåÈë3ÐпÉÒԳɹ¦£¬É¾³ýÖ»ÄÜɾ³ý1ÐУ¬²¢ÇÒµÚÒ»ÐÐɾ³ý3±é£¨ÒòΪÓÐ3ÌõÊý¾Ý£©¡£ ´úÂëÈçÏ£º¿ÒÇë¸÷λ¸ßÊÖÖ¸µãÒ»¶þ£¬Ð¡µÜ¸Ð¼¤²»¾ ......