LOAD DATA INFILE won't run correctly when running from VBscript

28/12/2007, 17h11

I have been having a hard time trying to figure out this problem. It
might be a simple suggestion but I am new to scripting and MySQL and
any would be greatly appreciated.

Problem:
I am trying to run a vbscript that will truncate a table in my
database and then load a csv file into the same database using Windows
Scheduled Tasks. When I try to load the file using vbscript it errors
out because of the carriage return character. If I go into the mysql
client window and copy and paste the line (below) it works correctly
but when executed through the vbscript it errors out. Are there any
suggestions.

Line:
LOAD DATA INFILE '/Program Files/MySQL/MySQL Server 5.0/bin/csv/
student.csv' replace INTO TABLE studentid FIELDS TERMINATED BY ','
LINES TERMINATED BY '%\n' (id, s_id, bday, lname, fname, mi);"

28/12/2007, 17h11	#1
jtrainaldi Messages: n/a Hébergeur:	LOAD DATA INFILE won't run correctly when running from VBscript I have been having a hard time trying to figure out this problem. It might be a simple suggestion but I am new to scripting and MySQL and any would be greatly appreciated. Problem: I am trying to run a vbscript that will truncate a table in my database and then load a csv file into the same database using Windows Scheduled Tasks. When I try to load the file using vbscript it errors out because of the carriage return character. If I go into the mysql client window and copy and paste the line (below) it works correctly but when executed through the vbscript it errors out. Are there any suggestions. Line: LOAD DATA INFILE '/Program Files/MySQL/MySQL Server 5.0/bin/csv/ student.csv' replace INTO TABLE studentid FIELDS TERMINATED BY ',' LINES TERMINATED BY '%\n' (id, s_id, bday, lname, fname, mi);"

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email