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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Code a button and Macro to Insert data to an Oracle Database (https://www.excelbanter.com/excel-programming/392823-code-button-macro-insert-data-oracle-database.html)

BI_Guy

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

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.

All times are GMT +1. The time now is 05:04 PM.