Import data from text file
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
Subject
Written By
Posted
Import data from text file
September 15, 2022 07:17AM
September 21, 2022 05:50PM
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.