MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


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


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.