ACCESS´íÎ󼯣¨²»¶Ï¸üУ©
1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1.Èç¹ûÄãµÄϵͳÊÇWin2003£¬ÔòÒªÔÚÄãÍøվĿ¼´¦ÓÒ»÷“ÊôÐÔ”->“°²È«”->Ìí¼Ó->ÊäÈë“Everyone”£¬²¢¸øÆäÍêÈ«¿ØÖƵÄȨÏÞ²ÅÄÜÕý³£Ê¹Óá£
2.Èç¹ûÄãµÄϵͳÊÇWinXP£¬Õâ¸öÎÊÌâÒ»°ã·¢ÉúÔÚ´ÅÅ̸ñʽΪNTFSµÄÇé¿öÏ¡£µã»÷“¹¤¾ß”->“Îļþ¼ÐÑ¡Ïî”->“²é¿´”£¬ÕÒµ½“ʹÓüòµ¥Îļþ¹²Ïí£¨ÍƼö£©”ÕâÏ°ÑÇ°ÃæµÄ¹´È¥µô¡£
ÔÚÍøÕ¾ËùÔÚÎļþ¼ÐÉϵ¥»÷ÓÒ¼ü£¬Ñ¡Ôñ“ÊôÐÔ”£¬Õâʱ¾ÍÄÜÕÒµ½“°²È«”µÄÑ¡Ï£¬Ìí¼ÓÒ»¸öÓû§Everyone£¬È¨ÏÞÉèΪ“ÍêÈ«¿ØÖÆ”¡£
Ïà¹ØÎĵµ£º
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
ÿ¸öº¯Êý¶¼¿ÉÒÔ½«±í´ïʽ £¨±í´ïʽ£ºËãÊõ»òÂß¼ÔËËã·û¡¢³£Êý¡¢º¯ÊýºÍ×Ö¶ÎÃû³Æ¡¢¿Ø¼þºÍÊôÐÔµÄÈÎÒâ×éºÏ£¬¼ÆËã½á¹ûΪµ¥¸öÖµ¡£±í´ïʽ¿ÉÖ´ÐмÆËã¡¢²Ù×÷×Ö·û»ò²âÊÔÊý¾Ý¡££©Ç¿ÖÆת»»ÎªÌض¨µÄÊý¾ÝÀàÐÍ £¨Êý¾ÝÀàÐÍ£º¾ö¶¨×ֶοÉÓµÓеÄÊý¾ÝÀàÐ͵Ä×Ö¶ÎÌØÕ÷¡£Êý¾ÝÀàÐÍ°üÀ¨ Boolean¡¢Integer¡¢Long¡¢Currency¡¢Single¡¢Double¡¢Date¡¢Strin ......
ÏÂÎçÔÚExcelµ¼ÈëSQLʱ£¬·¢ÏÖÔÁ¬½ÓExcelµÄÊý¾ÝÁ¬½Ó´®¹ýʱÔì³ÉеÄExcel¸ñʽ*.xlsxÎÞ·¨Ê¶±ð¡£
°ÑеÄÁ¬½Ó´®Ìæ»»~
·Ö±ð²âÊÔ03/07µÄExcelÎļþ¾ù¿Éͨ¹ý~
Office 97-2003°æ±¾
Excel: Provider= Microsoft.Jet.OLEDB.4.0;Data Source=ÎļþλÖÃ;Extended Properties=Excel 8.0;
Access: Provider= Microsoft.Jet.OLEDB ......
ÔÚ×öMobileÏîĿʱÓöµ½Ò»¸öÎÊÌ⣬ÎÒÃǵÄMobileÏîÄ¿ÐèҪʹÓÃSqlCeÊý¾Ý¿â£¬¶ø¿Í»§ÌṩµÄ´øÓÐÔʼÊý¾ÝµÄÊý¾Ý¿âÊÇAccess¸ñʽµÄ£¬ËùÒÔÎÒÃÇÃæÁٵĵÚÒ»¸öÎÊÌâÊǽ«AccessÊý¾Ý¿â£¨*.mdb£©×ª»»³ÉSqlCeÊý¾Ý¿â£¨*.sdf£©¡£ÍøÉÏËÑË÷µÄºÜ¶à×ÊÁÏÊǹØÓÚÈçºÎ½«SqlServer 2005ÓëSqlCeÊý¾Ý½øÐÐͬ²½£¬Ö÷ÒªÊÇͨ¹ý·¢²¼¶©Ôļ°RDA±à³ÌÀ´ÊµÏÖ£¬¿ÉÒԲο¼ ......
Access ÏîÄ¿¹ÜÀíÍÅ¶ÓµÄ Clint ÔÚ´ËÏò Office ¹¤³Ì²©¿ÍµÄ¶ÁÕß±íʾÎʺò¡£Í¨¹ýÓëµÚ 9 ƵµÀºÏ×÷£¬Access ÍŶӼ´½«ÍƳöÒ»¸öÃûΪ Access չʾµÄÐÂչʾ¡£ÆäÖ÷ÒªÈËÎï°üÀ¨ Ryan McMinn¡¢ÎÒ±¾ÈËÒÔ¼°ÍŶӵÄÆäËûÈËÔ±¡£ÎÒÃǽ«ÉîÈë̽ÌÖ Access 2010 ºÍ Access Services ÖеÄÐÂÔö¹¦ÄÜ£¬²¢·ÖÏíÀ´×ÔÉçÇøµÄ·´À¡¡£
´ËÍ⣬×î½üÔÚ SharePoint D ......