Please help me to solve the problem with Import of Excel/CSV file. Below is errors when executing import. Simple file and mySQL table but is not working.
Excel Data:
Client Last Name Client First Name Affiliate Rep App/Date Rec'd Multi Prop Signed Authorization Credit Notes
Lembach Charles City Capital Jevon X xxx X 742-qualified need docs
Antwi Estella City Capital A. Hall X xxx X 778-qualified need docs
Import
Browse to the comma-separated (.csv) or to the Excel (.xls) file that you wish to import.
The first line in the file should contain the field names.
--------------------------------------------------------------------------------
Select file with data
--------------------------------------------------------------------------------
Error: in the line: 'Lembach','Charles','City Capital','Jevon','X','xxx','X','742-qualified','need docs'
Error: in the line: 'Antwi','Estella','City Capital','A. Hall','X','xxx','X','778-qualified','need docs'
mySQL Table
Client Last Name varchar(50)
Client First Name varchar(50)
Affiliate varchar(50)
Rep varchar(50)
App/Date Rec varchar(50)
Multi Prop varchar(50)
Signed Authorization varchar(50)
Credit varchar(50)
Note varchar(50)
Thanks for your help.
anjeko