in reply to Re: Re: Re: From excel to mysql...
in thread From excel to mysql...


It is possible to enter newlines in an Excel cell, using ALT ENTER. The fields are then escaped in the CSV or TAB file using double quotes. So Hello\nWorld would look like this:
"Hello\n World"

--
John.