[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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/

¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£



[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]