I have some records in excel and I want to load them into oracle temp table. My intention is to use this temp table as a look-up table to update some values in a table.
The values are in Excel so I can convert them to any delimited file.
1) I DO NOT have access to UNIX so I am not sure if SQL Loader is an option for me.
2) There are not more than 500 records. Is it a good idea to generate insert statements? If yes how?
3) Can we write a procedure to read the file and load into temp table?
Here is the some sample records.
7591XXX $1,302.74 7591XXX $1,302.74 7591XXX $1,061.69
7590XXX $2,106.97 7590XXX $2,106.97 7590XXX $1,717.11
7590XXX $936.01 7590XXX $936.01 7590XXX $762.82
7590XXX $1,073.55 7590XXX $1,073.55 7590XXX $874.91
7591XXX N/A 7591XXX N/A 7591XXX N/A