- 9545 Views
- 9 replies
- 2 kudos
What is the best way to read in a ms access .accdb database into Databricks from a mounted drive?
I am currently trying to read in .accdb files from a mounted drive. Based on my research it looks like I would have to use a package like JayDeBeApi with ucanaccess drivers or pyodbc with ms access drivers.Will this work?Thanks for any help.
- 9545 Views
- 9 replies
- 2 kudos
- 2 kudos
Hi @Leland Adams​ Hope you are doing well. Thank you for posting your question and giving us additional information. Do you think you were able to solve the query?We'd love to hear from you.
- 2 kudos
- 6401 Views
- 2 replies
- 1 kudos
Resolved! net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 user lacks privilege or object not found: full questionnaire in statement [SELECT * FROM "full questionnaire" WHERE 1=0]
I have followed the steps given here to parse .accdb files using ucanaccess on Azure Databricks, however, I receive errors.See below my code:# Connection properties conn_properties = {"driver" : "net.ucanaccess.jdbc.UcanaccessDriver"} # Path url = ...
![net.ucanaccess.jdbc.UcanaccessSQLException_ UCAExc___5.0.1 user lacks privilege or object not found_ full questionnaire in statement [SELECT _ FROM "full questionnaire" WHERE 1=0]](/t5/image/serverpage/image-id/1952iDBC96B99046D53B6/image-size/medium?v=v2&px=400)
- 6401 Views
- 2 replies
- 1 kudos
- 1 kudos
@Valeri Nteleah​ please let me know if you need further help on this.Thanks
- 1 kudos