Given csv file 'example.csv'
I would like to load data in:
cell C7 into column X
cell D8 into column Y
cell F7 into column Z
of oracle table 'exampletable' And so on. The csv file does not have orderly rows and columns, so I cannot just load the csv file into a new table cleanly. So what I am asking is how to map cells to table columns loading this file into Oracle (XE). Can anyone point me to a tutorial?
I realize this is pretty elementary, please let me know if I have under-specified anything in the question.