Before I get started, let me say that I have looked at the manual, gone through a number of posts to the lists and read Paul's MySQL book. I've tried a lot of things over the course of the past three hours and am hoping that someone can shed some light on this one.
When I do the load data local infile, everything drops in fine EXCEPT for the last field in the list. It comes in blank and usually gives me an error. Here is a sample of my .csv file: "Texas A&M University","College Station, TX","1999","Design, install, test and run blah, blah.","Whatever Industry" Here is ONE of the many syntaxes I've tried that looks like it should cover it all: LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; But no. No matter what I try, .txt files, .csv files, with returns, without, the last field always gets dropped. I'm at my wits end, and that's a short trip on a GOOD day. The text file is done in wordpad or notepad and saved as plain text. Running on an NT server. Any help is appreciated. Thanks. Brent --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
