MySQL Forums
Forum List  »  Newbie

Re: Entering data when the value is the word "Null"
Posted by: Peter Brawley
Date: July 24, 2014 10:24AM

In LibreOffice or OpenOffice, export with the text delimiter set to ", then add Optionally Delimited By "" to your Load Data command.

Excel does not have that option. If you only have Excel, get LibreOffice or use a macro eg http://markinns.com/articles/full/export_excel_csvs_with_double_quotes

Options: ReplyQuote


Subject
Written By
Posted
Re: Entering data when the value is the word "Null"
July 24, 2014 10:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.