I need to Execute the LOAD DATA INFILE Command on a MySql dase remotely.
I have tried using
sqlstring = "LOAD DATA INFILE '/home/toolsfor/tmp/x_web.txt' REPLACE INTO TABLE x_web;"
From VBA and get the following error
[MySql][odbc 5.1 Driver][mysqld-5.0.92-community-log]Access denied for user'user@ipaddress'(using password: YES)
I have tried to put the LOAD DATA INFILE in a stored Procedure but get
ERROR 1314: LOAD DATA is not allowed in stored procedures