MySQL Forums
Forum List  »  Newbie

Create Mysql file from excel file where columns have text with numerous commas preventing a clean csv file.
Posted by: Dave Haslett
Date: February 27, 2024 10:41AM

Need to create a mysql file from and excel file. Excel file has three of 9 columns with multiple proper names with commas between each name. Cannot create a clean csv file due to all those commas. Thinking i need to use odbc and write code to read the excel file and output the sql file. Does anyone have a better idea how to approach this?

Many thanks for your help!!!

Options: ReplyQuote


Subject
Written By
Posted
Create Mysql file from excel file where columns have text with numerous commas preventing a clean csv file.
February 27, 2024 10:41AM


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.