Home » RDBMS Server » Server Utilities » Help converting excel spreadsheet into csv and loading in SQLLDR
Help converting excel spreadsheet into csv and loading in SQLLDR [message #73883] Wed, 28 July 2004 08:31 Go to next message
Raquel
Messages: 46
Registered: July 2003
Member
I want to load the contents of an excel spreadsheet into an Oracle table. When I convert the excel spreadsheet to csv it adds blank spaces in one of the fields. For example the cvs field in question will look like this: 10A   , 

How do I get rid of the blank spaces in this field prior to loading it into Oracle?

 

Report message to a moderator

Re: Help converting excel spreadsheet into csv and loading in SQLLDR [message #73888 is a reply to message #73883] Thu, 29 July 2004 01:41 Go to previous message
Tarun Biswas
Messages: 23
Registered: May 2004
Junior Member
pls remove the heading of excel file i.e. column name from execl file. then save it in csv

Report message to a moderator

Previous Topic: ORA-1555 during export
Next Topic: SQL Loader When Clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:36:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.