Loading Excel spreadsheet into Oracle [message #1000] |
Tue, 19 March 2002 21:08 |
Luis
Messages: 29 Registered: November 1999
|
Junior Member |
|
|
I have Microsoft Excel spreadsheets that I need to be loaded into Oracle tables on a regular basis. I saw something about using SQL Loader as long as there is a delimiter. The problem I have is that the delimiter may show up in the data and I thought I read somewhere that the delimiter cannot show up in the data. Will that screw up SQL Loader? If so, any ideas on how else I can load the spreadsheets? Help is GREATLY appreciated!!
Thanks in advance,
Luis
|
|
|
|
|
|
Re: Loading Excel spreadsheet into Oracle [message #1041 is a reply to message #1000] |
Sun, 24 March 2002 21:41 |
Srinivasa Raghavan K
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Sir,
There is a work around for this. if the data contains commas embedded in them, saving in .csv format may not help. Another way is create a new column after every column and populate these columns with (# or ! or any other delimiter). Then save this file as a text file and this file can be easily loaded as you have a delimiter in your file.
This could be a temporary workaround for you.
Srinivasa Raghavan K
|
|
|