Loading a Data File
Hi all,
I was just hoping someone could help me with uploading a .csv file to a table. The table already has 26 entries, and I want to bulk add an additional 170 or so. This is the code I have used, but isn't working:
LOAD DATA LOCAL INFILE ‘Macintosh HD/Users/lewis/Desktop/load file’
INTO TABLE table_name
FIELDS TERMINATED BY ‘,’;
Can anyone provide any advice or a solution?
Thanks in advance for any responses!
Subject
Written By
Posted
Loading a Data File
July 25, 2023 03:19AM
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.