Tag Info

New answers tagged


OPENROWSET command and Microsoft Access Text Driver (*.txt, *.csv) driver come to the rescue: SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={Microsoft Access Text Driver (*.txt, *.csv)}; DefaultDir=D:\CSV file directory; Format=CSVDelimited; CharacterSet=ANSI; ', 'SELECT * FROM [filename.csv]')


I have to import an external csv file into a table in database each day. ... Additionally, It is much appreciated if the importing could be done entirely without the need for GTTs and loading a file straight into the destination table. And that is what SQL*Loader was made for. SQL> create table employee ( id integer, name ...

Top 50 recent answers are included