What is the connect string between Oracle & Excel?
 

Dear All,

In excel spreadsheet I need to create a user search form. Form will
include 2 or more field for user to enter and create a button for user
to save the data.

So I need to manually connect to Oracle database using ODBC and select
some of the data from one of the table in Oracle and when user click the
button it will update or insert back to the oracle.

My ODBC Data Source Name are called "Cis2"
User ID = "Prog"
Password ="cis2prog"
Server = HKUAT

So I need one of the method like ether ADOX, ADO, DAO OR DataBase etc to
connect to oracle.

Could everyone can help me how to write that connection string to connect
to the oracle so that I can either use select or update or insert statment?

Thanks

david

What is the connect string between Oracle & Excel?
 

http://www.carlprothman.net/Default.aspx?tabid=81

--
Regards,
Tom Ogilvy

"David Willis" wrote in message
.com...
Dear All,

In excel spreadsheet I need to create a user search form. Form will
include 2 or more field for user to enter and create a button for user
to save the data.

So I need to manually connect to Oracle database using ODBC and select
some of the data from one of the table in Oracle and when user click the
button it will update or insert back to the oracle.

My ODBC Data Source Name are called "Cis2"
User ID = "Prog"
Password ="cis2prog"
Server = HKUAT

So I need one of the method like ether ADOX, ADO, DAO OR DataBase etc to
connect to oracle.

Could everyone can help me how to write that connection string to connect
to the oracle so that I can either use select or update or insert
statment?

Thanks

david