node.js - Insert records from CSV file into Oracle, with NodeJs

Question

I have a concern working with Oracle, TypeOrm, and NodeJs. How can I input 1 million records found within a csv file?

The point is that I have to load the content of an xlsx file to a table in oracle, this file has around 1 million data or more. The way I was doing this task was, converting from xlsx to json and from json, and that array save to database, but it was taking too long. So now I transform to CSV, but how can I insert all the records from the CSV file into the oracle table?

I am using TypeOrm for the connection between Oracle and NodeJs

question from:https://stackoverflow.com/questions/65546371/insert-records-from-csv-file-into-oracle-with-nodejs

Answer 1

Waitting for answers