Directory to Dynamic Input - What am I doing wrong?

[nvelazquez]

Hi all,

I am trying to input a group of files within a folder.

I am using directory to list all the files and then appending the sheet name to the full path. From there I connect the edited directory data to the Dynamic Input input tool. I select fullPath for my field and the first file in my group of files for the data source template. When I run the WF I get an error stating: Error: Dynamic Input (7): Error opening table: Microsoft JET Database Engine: Syntax error in FROM clause.\3000 = -526912946.

Can someone please help me fix the WF to input all the files at once? See pictures below for further detail.

Thanks.

Formula I am using. Filename2 is the same as the sheet name.

[Luke_C]

Hi @nvelazquez 

Try updating your formula to be the following. I added single quotes around the sheet name.

[FullPath]+"|||'"+[FileName2]+"$'"