Insert multiple CSV files into one oracle database

Question

I am looking to important around 100 csv files with the same data throughout all of them. I am using oracle SQL developer

Please add details of what you have tried and at what point you're encountering a problem. — devlin carnate
– devlin carnate, Commented Feb 6, 2020 at 16:13
Just to make sure: your database is MS SQL Server, and the tool you use is Oracle SQL Developer. It that correct? — Littlefoot
– Littlefoot, Commented Feb 6, 2020 at 16:13
I have tried to search up methods to do this and can't seem to find anything to do it in one bulk import. any tips? — Callum Jones
– Callum Jones, Commented Feb 6, 2020 at 16:14

ASH · Accepted Answer · 2020-02-09 16:48:31Z

2

Is this SQL Server or Oracle? Either way, if I were you, I would merge all 100 files into one single file, and load that into any database you are working with. Python will easily do the merge task for you. Then, load the consolidated file into your DB.

import pandas as pd
import csv
import glob
import os

#os.chdir("C:\\your_path\\")
results = pd.DataFrame([])
filelist = glob.glob("C:\\your_path\\test\\*.csv")
#dfList=[]
for filename in filelist:
    print(filename)  
    namedf = pd.read_csv(filename, skiprows=0, index_col=0)
    results = results.append(namedf)

results.to_csv('C:\\your_path\\CombinedFile.csv')

answered Feb 9, 2020 at 16:48

ASH

20.5k28 gold badges117 silver badges247 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert multiple CSV files into one oracle database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related