fra tekst fil til mySQL

noget ala :
http://www.eksperten.dk/spm/375718

?

prøver ;O)

dette:

strSQL = "LOAD DATA INFILE 'sql.txt' INTO TABEL 18amonth fields terminated by ',' lines terminated by '\r\n';"
Set rs = Conn.Execute(strSQL)


giver denne fejl:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-3.23.54-log]You have an error in your SQL syntax near 'TABEL 18amonth fields terminated by ',' lines terminated by '\r\n'' at line 1

/html/tekstfil.asp, line 4

Så prøv med:

lines terminated by '\n'";  istedet ...

Altså:

strSQL = "LOAD DATA INFILE 'sql.txt' INTO TABEL 18amonth fields terminated by ',' lines terminated by '\n'";
Set rs = Conn.Execute(strSQL)

samme fejl...

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-3.23.54-log]You have an error in your SQL syntax near 'TABEL 18amonth fields terminated by ',' lines terminated by '\n'' at line 1

/html/tekstfil.asp, line 4

der er en syntaksfejl et sted..

bemærk forskellen her:

lines terminated by '\n''      (din)
lines terminated by '\n'"      (min)

Hvad med at stave TABLE korrekt ;-)

HHEHHHEEEEEE

Loool  egonspock..

hehe... ok, ny fejl:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-3.23.54-log]Access denied for user: '*******@******' (Using password: YES)

/html/tekstfil.asp, line 4

Det er ikke syntaksfejl..

Du bruger bare det forkerte password, derfor ingen adgang til MySQL..

Kan du ikke paste hele scriptet herind..
Så kan vi hjælpe :D

jo da ;O):


En forbindelse (conn) bliver oprettet til databasen, vha. include. <--(den virker)


<!--#include file="******" -->
<%
strSQL = "LOAD DATA INFILE 'sql.txt' INTO TABLE 18amonth fields terminated by ',' lines terminated by '\r\n';"
Set rs = Conn.Execute(strSQL)
%>

lukker

ok

takker