4 Replies - 2476 Views - Last Post: 09 October 2007 - 03:16 AM

#1 rameshp  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 44
  • Joined: 29-July 07

export excell data to oracle

Post icon  Posted 28 September 2007 - 08:31 PM

hi Every one.
i am created some column in excell. in this all records can be export to oracle.

and how to import excell..

i am trying to like..
inexcell
steps..

1.goto data ..
2.import external data.
3.new database uery..
4.choose datasource..


and i am understand what next..

but i am created employee details ...

inthis
1)... excell to oracle..
2)...oracle to excell.

plse give me a suggestions.

Is This A Good Question/Topic? 0
  • +

Replies To: export excell data to oracle

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1658
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: export excell data to oracle

Posted 02 October 2007 - 05:03 AM

Transferring Excel to Oracle, theres some instructions for your quandary. And if those don't work try here.

A little bit of work from you would have found the same solutions, so next time put in some work before asking for help, since that is the rules of this forum :)
Was This Post Helpful? 0
  • +
  • -

#3 rameshp  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 44
  • Joined: 29-July 07

Re: export excell data to oracle

Posted 08 October 2007 - 09:32 PM

View PostPsychoCoder, on 2 Oct, 2007 - 05:03 AM, said:

Transferring Excel to Oracle, theres some instructions for your quandary. And if those don't work try here.

A little bit of work from you would have found the same solutions, so next time put in some work before asking for help, since that is the rules of this forum :)



thanks PsychoCoder

your rules some dis advances aslo.

i am importing oracle to excell.
but excell to oracle it is not possible..
we r purchasing another third party tool...

i know..
but it is posssible or not i am asing before ..
i am trying to manipulate some records it effected at oracle..
but 1...i want to enter some data in excell.
2....it direct goes to oracle..
3...it is not possible in excel..


ok

in some body dont know some thing.. they are trying to learn ..
i have basic knowledge..
i am trying to improving programming knowledge
i am posting..
i dont no some times how to start program's..
but u said rules against it..
learning some problem...
tell me forum means..
i am expecting some experts are they they give some suggestions and coding..
suppose any home work is given..
he/she can cut to past his/her knowledge can not improving..
ok...
i am trying so many things..

ok
sorry..
bye..
rammm
Was This Post Helpful? 0
  • +
  • -

#4 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1658
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: export excell data to oracle

Posted 08 October 2007 - 09:39 PM

I never said it was possible to do a straight export to Excel from Oracle, or vica versa. There are always hurdles we need to get around. The link I offered showed you what needs to be done to accomplish your task.
Was This Post Helpful? 0
  • +
  • -

#5 rameshp  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 44
  • Joined: 29-July 07

Re: export excell data to oracle

Posted 09 October 2007 - 03:16 AM

View PostPsychoCoder, on 8 Oct, 2007 - 09:39 PM, said:

I never said it was possible to do a straight export to Excel from Oracle, or vica versa. There are always hurdles we need to get around. The link I offered showed you what needs to be done to accomplish your task.



hi,
in excell import data is available..
in that we are connecting through dsn or like..
to conncet database..
in that we have selected tables..
and run at Microsoft quarry wizard
running sql queries..
hear auo updations possible one table..
and we selected fields transfer to excell directly..
all fields and rows be in excell..it possible..
but my plan is
we are created dummy table like emp1 as emp.
no rows avilable..
we enter 30 rows in excell
modification query ..
it is not possible.,..
but i want to export .. excell to oracle through datasource connections..
thanks
ram..
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1