July 10th, 2003, 12:29 PM
Query to MySQL by VBA
I have this strange question, I wanna pass a query to a MySQL Db from Vb
Now I am riting this query as:
str = "load data infile 'c:/trial.csv' into table trial fields terminated by ',' enclosed by '" ' "
but there is an error in the last part...
Can ne one help me out with this?
Thanx n regards.
July 10th, 2003, 10:31 PM
Can you post the error message? Are you fields enclose by a single tick or a double quote?
July 11th, 2003, 08:47 AM
Hey thanx, I got hold of the problem yest evening. actually had to give a " between two 's so...the second part was not being detected. Got around by giving an ANSII character in place of that.
Neways, thanx again for your help.