ODBC connection excel VBA to Snowflake connection string needed
Need to connect excel VBA to snowflake. Can anyone provide a connection string for that?
1 answer
There is no ADO connection string for Snowflake. You have to access it via ODBC Data Source.
[ODBC]
driver={SnowflakeDSIIDriver}
server=
database=
schema=
warehouse=
role=
Uid=
Pwd=
You will need to go to the following link to install the most recent Snowflake drivers.
https://sfc-repo.snowflakecomputing.com/odbc/index.html