ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

python ¿Ä¸ê¿Ä¨é·JÁ` (¥þ³¡)"¸ê®Æ

¦^´_ 4# lpk187
Thanks a lot!

TOP

¦^´_ 6# koshi0413


    ¬d¸ß³t«×¡AÀ³¸Ó©M¸ê®Æ®w¥»¨­¦³«Ü¤jªºÃö«Y¡IAccess¥»¨­¡A´N¥u¬O­Ó¤H¹q¸£©Ò¨Ï¥Îªº¤p¤p¸ê®Æ®w¡A
·íµM­n³B²z¹³ªÑ¥«¸ê°Tªº¸Ü¡A§Ú¤£·|±ÀÂË¥ÎAccess ¡AÁöµM·L³n¸¹ºÙ¥i¹F·¥­­¬°2G¡AÁöµM§Ú¨S¸Õ¹L¹F¨ì2G·¥­­­Èªº³t«×¡A
¤£¹L¨Ì§Ú·Q¤j·§ºâ¥¦10%¦n¤F¡A¨ä³t«×¤j¬ù´N·|¦³©úÅ㪺®t²§¤F¡C
ÁÙ¦³¦U¤è¼Ò¶ô¡A³£¦³¨äÀu¶Õ¡A·í§Ú¥¿¦b¾Ç²ßpython®É¡A¦³¬Y­Ó¼Ò¶ôªº¬Y¨ç¼Æ¤ñ¥t¥~¼Ò¶ôªº¨ç¼Æ±j®É¡A§Ú·|¥Î³o­Ó¼Ò¶ô¡A
·íµM¡A³o¥u¬O«ü§Ú¥Ø«e¥¿¦b¾Ç²ß¶¥¬qªº·Qªk¡A(¦]¬°ÁÙ¤£¬O«ÜÁA¸Ñ¨ä¨ç¼Æ¥Îªk)

TOP

¥»©«³Ì«á¥Ñ koshi0413 ©ó 2016-9-23 00:00 ½s¿è

¼F®`¡A¤p§Ì¾Ç²ß¥ý¡A¦³°ÝÃD¦bµo°Ý~

¹ï¤F¡A¥ý´£°Ý¤@¤U  acc ªº¸ê®Æ¬d¸ß³t«×  ¸ò  sqlite3 ¤ñ¸û¤@¤U¡A¦óªÌ§Ö©O¡H

¤p§Ì¬Oµ{¦¡·s¤â¡A©Ò¥H¤°»ò³£¤£À´¡A·|¶Ãµo°Ý¡A½Ð¨£½Ì¼K~~

TOP

¥H¤U¬O§Ú°õ¦æªº¹Lµ{¡G






TOP

¥»©«³Ì«á¥Ñ lpk187 ©ó 2016-9-22 22:04 ½s¿è

¦^´_ 3# c_c_lai


    pypyodbc ©Mpyodbc¬O¤£¦Pªº¡A­n¤U¸üpypyodbc ÁÙ¬O­n¦bCMD ¤¤¤U¸ü
pip install pypyodbc




pypyodbc ¨ä¥Îªk§Ú¤]¤£·|¡A¤£¹L·í®É¥u¬Ý¨ì¤@¥y«ü¥O´N¥i¥H²£¥Í¸ê®Æ®w¡A©Ò¥H§Ú´N¤U¸ü¤F
¨ä»yªk¬°    pypyodbc.win_create_mdb( os.getcwd() + '\\twsedata.mdb')

TOP

¦^´_ 1# lpk187
½Ð°Ý pypyodbc ¦p¦ó¤U¦A¦w¸Ë¡H
§Ú¦w¸Ë¤F Anaconda ¤ºªþªº pyodbc µ²ªGÁÙ¬O¤@¼Ë¡C

TOP

¦^´_ 1# lpk187
¤Ó´Î¤F¡I
¥ý¨Ó¸Õ¸Õ¬Ý¡AÁÂÁÂÅo¡I

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD