Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello!
Few weeks new to Alteryx Designer.
I have several queries in Access Database ("AD") that I want to use in Alteryx via ODBC or OLEDB connections.
I do not want to create them manually using the Alteryx built in SQL Editor.
If I copy and paste the Access SQL STMT in Alteryx, I get an invalid object error.
When I convert the SQL STMT from DBO_ to DBO.
I get an invalid column name error.
Anyone has recommendation(s) to fix this issue or to convert Access SQLs to Alteryx?
