Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming | |||
don't find my message : connect to oracle db (4.2. 19:39) | Excel Programming | |||
connect to an oracle db | Excel Programming | |||
Connect to Oracle Database through ODBC with VBA | Excel Programming | |||
connect to an oracle server | Excel Programming |