SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to create the temp table in Sybase with values from Excel ?

549379Apr 10 2008 — edited Apr 11 2008

Dear Sir/Madam,
I know this is not related with oracle DB, however i am in the need of help from you people who worked on Sybase. plz help me..

I have the excel sheet which contains EmpId and EmpName values. I just wanted to read these two values one by one from an excel sheet and loaded them into one temp table in Sybase. is it possible thru sqlldr ?
here is the sample code for your reference:

begin tran

create table tempdb..empIdName (emp_id int identity,emp_name varchar(50))
go

Awaiting for your valuable reply
thanks
pannar

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2008

Added on Apr 10 2008

7 comments

1,339 views