Re: Import Excel data into table [modified]

[beacker]

I forgot one element

LOAD DATA LOCAL INFILE 'a.csv' INTO TABLE Users
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    (id,firstName,lastName);

Brad ([EMAIL PROTECTED])



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]