What is the connect string between Oracle & Excel?

D

David Willis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection Oracle Web Service Problem 0
How to access date from Oracle Databace to Excel 1
Code a button and Macro to Insert data to an Oracle Database 0
insert into oracle commit 0
Oracle Connection 0
Problem wqith connection to Oracle 1
Excel-MSQuery Out Of Memory error 0
DAO & ADO within the Same Application? 1

Top