![]() Microsoft ActiveX Data Objects Recordset 2. Microsoft ActiveX Data Objects 2.8 Library Microsoft Visual Basic for Applications Extensibility 5.3 Here is a list of the reference libraries used in this VBA project: Is it possible to attach the OraOLEDB.Oracle.1 code as a file and then have the VBA code install it if needed?Ĭnct = "*Provider=OraOLEDB.Oracle.1* Data Source=PDW User Id= Password=" Can I programmatically check if the other system has the driver and if not, programmatically load the driver?Ĥ. Does the other system have to have Oracle client loaded or can I just load the driver software (OraOLEDB.Oracle.1)?ģ. What drivers do I need to provide to the other users so that the macro can run?Ģ. (optional) remove Writeprotection (ODBC-Options) if you want to write to. Create a ODBC-DSN selecting Excel Driver / your file. psqlODBC is developed and supported through the mailing list. here's a quick guide to use Excel via ODBC: 1. The macro stops at the Connection.Open line because it does not recognize "OraOLEDB.Oracle.1"ġ. Example based Mini-Howto on using Microsoft Access VBA with PostgreSQL. ![]() However, the other machines do not have Oracle client loaded on their systems. I am now giving this macro to others in my organization so they can also use it. It uses the Provider 'OraOLEDB.Oracle.1'. I have a VBA macro that connects to an Oracle db and pulls data into Excel using ADO. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |