I am trying to execute a "LOAD DATA INFILE ..." query using an ADODB connection.
Here is the query that I am trying to execute:
Code: Select all
LOAD DATA INFILE 'C:\\xampp\\xampp\\htdocs\\localamp\\modules\\billing\\importedFiles\\discovery.csv' REPLACE INTO TABLE discovery FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ' \n' (member_no,dependents_no,name_last,initials,inception_date,effective_date,plan_type_id,ceb,vit,pty,contribution,msa,ancil,premium,split_amount,total_amount)If I run the query in command line or in phpmyadmin it works 100%.
Here is the execution point in my code:
Code: Select all
$results = $connection->execute($sql);