Hey everyone,
I'm connecting to Smartsheet ODBC using an API token and I'm able to see all of the Smartsheets that are accessible to me in the "tables" tab. The problem I'm having is when I try to pull data from the Smartsheet by double-clicking, I get this error: "Error SQLPrepare: There was an error executing an SQL query: 'table "[table_name]" already exists' (1)"
This is the query:
SELECT * FROM "[account_email]"."[smartsheet_name]_1625175939671940s_(Home)"
The Smartsheet title ends at "list" - I'm not sure why it added all those numbers and "(Home)" but not sure if that matters?
I can't find anything online about this error other than a paywalled article that I can't read, so I'm hoping someone here has the answer on how to fix this.
Thanks in advance!
Solved! Go to Solution.
Never mind, I figured out I just needed to remove my email in the front of the table name. :)