This is an example of my csv converted from excel
17,JOSEFA V. SANTOS,,2004-06-15,XPEIT,440557,
the , is of course the dellimiter, but dont i need the "" to enclose data?
and as you can see i have ,, it indicates blank data to be inserted.
the columns are idnum, name, address, date, course, certificate_num
I need to convert my excel file, because it contains 100,000 rows of info.
or if you have a free converter for an access file to mysql please send some links, i can only find shareware on the net.
I've also tried exporting a data from mysql and save it as csv, then i edited the csv and import it back to mysql. there still errors.
maybe i'll just stick to access to mysql converter, do you have freeware versions?
thank you so much.