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?
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")
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
