CData Excel Add-In for OData 2019 - Online Help
Questions / Feedback?

Connecting from VBA

CData Excel Add-In for OData 2019 - Build 19.0.7354

To execute SQL to OData, initialize an ExcelComModule instance. This class can be used with any CData provider. You can call the following methods to initialize the module for working with OData:

  • SetProviderName
  • SetConnectionString

You can use the following code to start Querying Data.

Dim module As New ExcelComModule
module.SetProviderName ("OData")

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0