Start Updating excel data with dsn less connection vba

Updating excel data with dsn less connection vba

Can anyone tell me how I can create a DSN-less connection to an Oracle database using VBA?

You can keep the data in your workbook up to date by "refreshing" the link to its source.

Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.

Recordset Dim s SQL As String 'Create objects Set CN = New ADODB. then check the option Microsoft Active X data object 2.5 or 2.6 library from the list.