mysql:5997
From: "Yoshitaka Ichikawa" <"Yoshitaka Ichikawa" <y_ichikawa@xxxxxxxxxx>>
Date: Tue, 27 Aug 2002 13:05:14 +0900
Subject: [mysql 05997] VB ¤«¤é LOAD DATA ¤¬»È¤¨¤Þ¤»¤ó
¤³¤ó¤Ë¤Á¤Ï¡¢»ÔÀî¤È¿½¤·¤Þ¤¹¡£ ¡ü¥·¥¹¥Æ¥à¾ðÊó ¥µ¡¼¥Ð¡¼¡¡OS:W2K Server¡¡MySQL:3.23.49 ¥¯¥é¥¤¥¢¥ó¥È¡¡OS¡§W2K Professional¡¡MySQLODBC¥É¥é¥¤¥Ð:3.51 ¡ü¥×¥í¥°¥é¥à¤ÎÆâÍÆ AS/400¤«¤é½ÐÎϤµ¤ì¤ëCSV¡¦XLS·Á¼°¤Î¥Õ¥¡¥¤¥ë¤ò¶¦Í¥Õ¥©¥ë¥À¡ÊÎ㡧 \\192.168.0.1\webdb\¡Ë¤«¤é¼èÆÀ¤·¡¢²¼µ¤Î½èÍý¤ò¹Ô¤¤MySQL¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë½èÍý ¤ò¹Ô¤¤¤Þ¤¹¡£ ¤½¤ì¤«¤é¡¢MySQL¥µ¡¼¥Ð¡¼¤Ï¡¢¤³¤ÎEXE¤ò¼Â¹Ô¤¹¤ëPC¤È¤ÏÊ̤ÎPC¤Ç²ÔÆ°¤·¤Æ¤¤¤Þ¤¹¡£ ¡¦¥Õ¥¡¥¤¥ëÊÑ´¹ XLS¡¡¢ª¡¡CSV ¡¦Ê¸½ñÀ°·Á 1.±Ñ¿ô¡¡¢ª¡¡Á´¤ÆȾ³Ñ 2.¥«¥Ê¡¡¢ª¡¡Á´¤ÆÁ´³Ñ 3.ê¡¡¡¡¢ª¡¡¡Ê³ô¡Ë 4.Ⱦ³Ñ¡Ö¡¦¡×¡¡¢ª¡¡Á´³Ñ¡Ö¡¦¡× 5.µ¡¼ï°Í¸ʸ»ú¡¡¢ª¡¡È󵡼ï°Í¸ʸ»ú ¡¦ÊÑ¿ôÅù OUT_FILE = API(Temp) & "\outfile.txt" Chr(&H22) ¢ª¡¡'¡É'¥À¥Ö¥ë¥³¡¼¥Æ¡¼¥·¥ç¥ó ¡üSQL¤Î¥³¥Þ¥ó¥É load_co.Execute "load data local infile '" & OUT_FILE & "' into table meigara fields terminated by ',' enclosed by '" & Chr(&H22) & "' lines terminated by '\r\n';" ¡ü¼Â¹Ô»þ¥¨¥é¡¼'-2147467259(80004005)': [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]The used command is not allowed with MySQL Version °ø¤ß¤Ë¡¢¡Ö¤«¤Í¤ä¤óMySQLAdmin¡×¤È¤¤¤¦¥Õ¥ê¡¼¤Î´ÉÍý¥½¥Õ¥È¤Ç¡¢¤³¤ÎSQL¥³¥Þ¥ó¥É¤ò SQLȯ¹Ô¥¦¥¤¥ó¥É¥¦¤Ç¼Â¹Ô¤·¤¿·ë²Ì¡¢Àµ¾ï¤Ë¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤·¤¿¡£ http://www.mmdb.net/m_kaneko/ ¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£