Home » Other » General » connect oracle 10g with openoffice.calc
connect oracle 10g with openoffice.calc [message #572719] Sun, 16 December 2012 10:36 Go to next message
Messages: 7
Registered: December 2012
Location: india
Junior Member
I have created odbc connection for oracle so that the data i will update in excel sheet that will be updated in my oracle database.
I am using oracle database 10g on Windows XP.
My openoffice.calc version : openoffice.org 3.0.0
I followed these steps:
start menu => settings => control panel => administrative tools => data sources(odbc)

odbc => user dsn tab => add => select driver name => microsoft odbc for oracle .
=> data source name: demo_dsn
description : any
username : hr
server : orcl (from tnsnames.ora)

open openoffice.calc

file => new => database

database wizard dialog box:

select connect to an existing database => odbc => next => odbc ds name: browse : demo_dsn => next => user name :hr(check password check box) => click on test connection
=> enter password=> connection established successfully.
All the tables in HR schema are now showing in my excel db.When am updating data in oracle, update is showing in my excel sheet.But the reverse
is throwing error. when am trying to update data from excel sheet its showing

Error updating the current record.
[Microsoft] [ODBC driver manager]driver does not support this attribute/option

Thanks in advance.
Re: connect oracle 10g with openoffice.calc [message #572720 is a reply to message #572719] Sun, 16 December 2012 10:57 Go to previous message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is an OpenOffice question not a Oracle database one.
I'm not sure you have chosen the correct forum to get an answer.
I move your topic from SQL to General (sub)forum as we have no forum for this (new) part of Oracle.

Anyway, I'm not sure there is some direct read/write ways to do this, that is without programming anything.

Previous Topic: UNDO tablespace is full
Next Topic: rsync - Oracle directories
Goto Forum:

Current Time: Tue Aug 09 00:28:18 CDT 2022