MySQL Forums
Forum List  »  Newbie

Import data from text file
Posted by: David Carpenter
Date: September 15, 2022 07:17AM

Hello,

I am trying import data from a tab separated extract from a MSSQL database and the table is only one column, however the data contains tabs in the data, which means the data is ending up in the next column, how do I prevent this from happening using the below statement?

LOAD DATA LOCAL INFILE 'H:/BCPFiles/test.txt' INTO TABLE test

Options: ReplyQuote


Subject
Written By
Posted
Import data from text file
September 15, 2022 07:17AM
September 21, 2022 05:50PM
October 11, 2022 01:29AM


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.