"Jan Broermann" <[EMAIL PROTECTED]> wrote:
> Hi, I've got a little Excel Macro that connects to
> MySQL via ADO below is the code. Funny thing is
> it connects to the database and executes the truncate
> orders without a problem.
>
> But when I come to Load data in file i receive an
> [MySQl][ODBC 3.5.1 Driver][mysql-4.0.18-nt]Access denied for user
> :'[EMAIL PROTECTED]' (using password: No)
>
> But, access is set to usage and user and password are ok. So what's bugging
> MySQL?
User must have FILE privilege to use LOAD DATA INFILE.
>
> here is the code:
>
> Set conn = New ADODB.Connection
> With conn
>.ConnectionString =
> "ODBC;DSN=Sport;option=65536;user=sport;password=IDONTTELLYOU;-)"
>.Open "DSN=Sport"
>
>.Execute ("TRUNCATE TABLE `angebot` ")
>.Execute ("TRUNCATE TABLE `anbieter` ")
>.Execute ("TRUNCATE TABLE `kategorien` ")
>.Execute ("TRUNCATE TABLE `kategorien_sportart_zuordnung` ")
>.Execute ("TRUNCATE TABLE `sportart` ")
>.Execute ("TRUNCATE TABLE `sportstaette` ")
>
>.Execute ("LOAD Data infile '" & ThisWorkbook.Path & "\angebot.csv'
> into table angebot")
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]