It is not clear from your post what the exact issues is, but you can start by reading these tips on using ODBC driver within R https://db.rstudio.com/r-packages/odbc/
If still stuck, please create a reprex. A reprex consists of the minimal code and data needed to recreate the issue/question you're having. You can find instructions how to build and share one here: