Dark forces indeed...! OK, OK... Now I have got it working using a local file on the HDD. Next - integration with PHP:
using the following syntax: $Upload= "LOAD DATA LOCAL INFILE '/public_html/CSVFILENAME.CSV INTO etc does not seem to work and provides no error even though I'm trapping any. I have a commend that changes the file permissions to read only ALL but still no joy. If I use a local file, fine such as C:\CSVFILENAME.CSV but not the above path (and I checked, the file's actually there sitting and waiting). Strange. Any ideas guys...? -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Harlequin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I am using the following command and it appears to execute but does not >actually load any data: > > LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE > MembersData > FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n'; > > Any ideas what I might be missing...? > > The file exists, and I must have the path right or would get an error but > still no joy unfortunately... > > -- > ----------------------------- > Michael Mason > Arras People > www.arraspeople.co.uk > ----------------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php