"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]
