I know using to referring column name with space when using sql in R, but how to referring a table name with space? I tried code below, failed to me. Thank you.
dim_Organization1 <- sqlQuery(odbcChannel1,
"select Organization,
[Organization Street Address] from [dim Organization]")