Forum Discussion
johnvonc
Jun 03, 2024Copper Contributor
Databricks with Simba spark ODBC dsn
I am using the Simba Spark ODBC driver to create a dsn to connect to a Databricks instance. When tested, it passes. When I go in to Access to link to the data, Access is only pulling a subset of the available tables and views. If I try to attach Databricks to Excel, using the same dsn, it returns all schemas, views and tables. Any help would be appreciated getting Access to work correcctly.
- Tom_van_StiphoutSteel ContributorAs a test, since you know the tables, use Database.CreateTabledef to create one of the "missing" ones. Does it work?
https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/database-createtabledef-method-dao- johnvoncCopper Contributor
Tom_van_Stiphout no luck. Access can't find the tables. Oddly, if I attempt to connect to the Databricks data using the same ODBC dsn using Excel, it works perfectly.
- Tom_van_StiphoutSteel ContributorYeah, you mentioned Excel in first instance.
Do you have a link to Databricks and to the ODBC driver?
What exact version of Access (File > Account) are you using?