|
|
|
|
| Re: How to access oracle tables from excel worksheet??? [message #70394 is a reply to message #70370] |
Fri, 07 June 2002 01:56   |
Anil
Messages: 80
Registered: September 2001
|
Member |
|
|
Hi,
Thankyou for the reply.
I have one more question to ask you. I really did not understand what you mean with "program with ODBC"?? And if I make excel file to .txt file, i mean if i change it directly the extension of the file from .xls to .txt then does it work?
And finally, if i want to use oracle tables into excel what i have to do??? I am trying for this option also. I created a table in oracle through sql, now i want to use that table in excel, what step to be adopted?? Please make them step by step procedure.
Thank You,
Raj.
|
|
|
|
| Re: How to access oracle tables from excel worksheet??? [message #70407 is a reply to message #70370] |
Mon, 10 June 2002 17:03 |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
"Program with ODBC" means to develop a program with using ODBC link to Oracle database.
I have tested with text file and chance to xls. It is able read by excel, the important thing is the format of file between txt and xls.
I don't think you can create a table in excel. Only access can have table,sql, like rdbms (single user).
Hope this is helping.
|
|
|
|
| Re: How to access oracle tables from excel worksheet??? [message #71188 is a reply to message #70370] |
Sun, 22 September 2002 21:00 |
ruwan
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
I'm Tring to get the web shot, throught servlet and sql query from excel worksheet.
So 80% from the job i have finshed (usinf ODBC ). so what I want to know is every oracle function and keyword can be user there.(In this case my databese is excel worksheet).
or
how could i create a oracle table dynamicaly.(run time)
or.
give me better solution to finsh this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
