MySQL Forums
Forum List  »  Newbie

Re: Create Mysql file from excel file where columns have text with numerous commas preventing a clean csv file.
Posted by: Barry Galbraith
Date: February 26, 2024 09:33PM

Can you save your Excel file as Tab Delimited text instead of CSV?
Then you can import the excel file specifying Tab (\t) as the delimiter.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Create Mysql file from excel file where columns have text with numerous commas preventing a clean csv file.
February 26, 2024 09:33PM


Sorry, only registered users may post in this forum.

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.