Reading file into mysql
Posted: Fri Aug 06, 2004 9:03 am
I've just been handed a Word file which contains a two column table that is 9 pages long which I now need to put into an equivalent mysql table.
No way do I want to retype it all to get it into the table! I've heard a bit about CSV files but don't know much about them. I'm just looking into mysqlimport but I don't know how to format the text file to get it to read the information correctly!
Can anyone give me a nudge in the right direction?
No way do I want to retype it all to get it into the table! I've heard a bit about CSV files but don't know much about them. I'm just looking into mysqlimport but I don't know how to format the text file to get it to read the information correctly!
Can anyone give me a nudge in the right direction?