Code a button and Macro to Insert data to an Oracle Database

B

BI_Guy

How can I code a button and to insert spreadsheet data through an ODBC
connection to an Oracle Database Server?
We require that ODBC prompt for Server, Userid and Password.
We do not want to code ADO prompts for the userid and password.
 

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

Using VBA to change Crystal Reports settings from Oracle to SQL 0
Review of Microsoft.Jet.OLEDB.4.0 Connection 0
calls to extract data from an open database 4
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
Can Excel talk to a back end? 1
insert into oracle commit 0
Programmatically setting pivot sourcedata 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top