Comments by JaffreenaMichael (Top 1 by date)

<pre lang="css">load data infile 'D://TempFolder/A/B/Book1.csv'
into table customers
fields terminated by ','
lines terminated by '/n';</pre> if columns in .csv file matches columns in table
then it shouls work fine following this query