In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Converting Access DB queries to Alteryx

pnshah
5 - Atom

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?

Invalid Object Error.PNGInvalid Column Name Error.PNG

 

 

 

0 REPLIES 0
Labels
Top Solution Authors