#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Detroit, US
    Posts
    5
    Rep Power
    0

    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.
    A
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Can you post the error message? Are you fields enclose by a single tick or a double quote?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Detroit, US
    Posts
    5
    Rep Power
    0
    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.
    A

IMN logo majestic logo threadwatch logo seochat tools logo