Hi yall, I'm trying to figure out how to import a small excell sheet (about 80 rows) into my mySQL database. I'm using phpmyadmin but I'm not sure how I'm suppose to set up my fields in excell so that it imports properly.. I've saved it as a csv but it keeps telling me that I need to have each field end with either a semicolon or coma...I've tried both... and then enclosed in quotes but I haven't been successful at importing yet... jeez, it's giving me a headache....is it normal to have to wrap every single entry in quotes and end them with semicolons or comas?... is there a faster way for me to get my existing excel data into this format? when I exported some sample data in my table into a csv file it wrapped all of the data with:
I'm just getting started with this so sorry if these questions seem ridiculous but I appreciate any and all help!!