[R-SIG-Mac] RODBC

[Emilio]

Hi,

I'm having trouble reading into R an access table (.accdb) with a Mac OS X 10.11.6 

I've created a DSN connection to my data base so when I use the odbcConnect function it returns:

RODBC Connection 1
Details:
     case=nochange
     DSN=mydsn
     UID=Admin
     PWD=******

So when I try to use sqlQuery(channel, "SELECT * Table")
Returns
[1] "HY000 0 [Actual][Access] near \"Table\": syntax error"
[2] "RODBC ERROR: Could not SQLExecDirect 'SELECT * Table'"

Please help me, I'm not familiar with Access at all.