Home » Open Source » Programming Interfaces » I don't have database
I don't have database [message #266188] Mon, 10 September 2007 02:44 Go to next message
nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN
Junior Member

Hi,

I don't have database but i have 10g DS. I have excel file and i want to connect this excel file to the sqlplus 10g(DS) how can i connect this file ? its very urgent please let me know ?

Thanks in advance

Noman Nishat
Re: I don't have database [message #266194 is a reply to message #266188] Mon, 10 September 2007 02:56 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It's not possible.

You will either have to create a database and load the data into the database ( which can not be done in an 'urgent' environment unless you know exactly what you are doing ) or access the excel file some other way, with Access maybe.
Re: I don't have database [message #266196 is a reply to message #266188] Mon, 10 September 2007 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ its very urgent
Nothing is urgent in a forum

2/ You must have an Oracle database

Regards
Michel
Re: I don't have database [message #266234 is a reply to message #266188] Mon, 10 September 2007 04:44 Go to previous messageGo to next message
nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN
Junior Member

hi,
Actually i have one excel sheet and somebudy told me that u can reterive the this data which is in excel sheet through sqlplus of 10g(DS). Can u tell me how?

Thanks
Noman Nishat
Re: I don't have database [message #266238 is a reply to message #266234] Mon, 10 September 2007 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in "You must have an Oracle database"?

Regards
Michel
Re: I don't have database [message #266241 is a reply to message #266188] Mon, 10 September 2007 04:55 Go to previous messageGo to next message
nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN
Junior Member

ok thanks
Re: I don't have database [message #266368 is a reply to message #266234] Mon, 10 September 2007 11:55 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
nomannishat
Somebudy told me that u can reterive the this data which is in excel sheet through sqlplus of 10g(DS).

I believe that buddy of yours meant you could use the external tables feature (available from 9i onwards). A standard pathway is to save Excel file as a CSV (comma separated values) file and load it into an Oracle database using either SQL*Loader utility or make this file an external table.

However, as previously stated, Developer Suite (you installed) is simply not enough - you have a tool (SQL*Plus), but you don't have a database to connect to. Or, do you have it, but didn't tell us?

Just being curious - once you find a database and load data from Excel file into it, what do you plan to do with these records?
Previous Topic: Latest JDBC driver throws strange error while querying LONG
Next Topic: 64 Bit Oracle on 64 bit XP
Goto Forum:
  


Current Time: Thu Mar 28 13:31:12 CDT 2024