Start Free Trial

Alteryx Designer Desktop Discussions

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

Microsoft JET Database error

jazzychan
5 - Atom

Can anyone help with this error. "Error Opening table: Microsoft JET Database Engine: Syntax error in FROM clause.\3000 = -526912946."

 

I receive the error in the Dynamic Input tool.  I can import file using the Input data tool with no issue.

1 REPLY 1
jazzychan
5 - Atom

was using these 2 filters but i updated to single quote. changed Action to Change Entire File Path and it fixed the syntax error.  but now i'm getting a No table chhoosen; please select a table from data source error.  

Contains([FileName], "JPMCENTRAL")

Contains([FileName], "04.28.2025")

Labels
Top Solution Authors