I've tried importing the text file below into myslqadmin using :
LOAD DATA INFILE emails2.txt to TABLE EMAILS2;
but no luck.
I know there are white space gaps throughout data below
but I dont know if that's the problem and if so how to get rid of them.
They were created by saving an excel file as csv
http://a-ability.com ,sales@a-ability.com ,A-Ability Medical Equipment
http://aacintervention.com ,julie@aacintervention.com ,AAC Intervention.com
http://accessibilitylifts.com ,info@accessibilitylifts.com ,x
http://adaptive-tech.uoregon.edu ,jbailey@darkwing.uoregon.edu ,University of Oregon
http://alphabetaomega.netfirms.com ,info@netfirms.com ,"Netfirms, Inc. "