Please forgive me if this is a very simple task, but I am struggling to execute it. I will try to explain it as best I can.
I have successfully connected RStudio to a SQL Server via an odbc connection.
Once connected, all the databases within that server are visable on the right side. I only want to work with one particular DB at the moment, but I'm unsure as to how to reference it in R Studio.
I am completely new to R and am learning via the internet (so it's a nightmare tbh haha)
Any help you could give me would be greatly appriciated.
Thanks in advance.