Hi ,
I am getting error as below. Please let me know if anyone has any solutions.
Dynamic Input (12) Error opening table: Microsoft Access Database Engine: The Microsoft Access database engine could not find the object Make sure the object exists and that you spell its name and the path name correctly.
I have installed Microsoft drivers: http://www.microsoft.com/en-us/download/details.aspx?id=3 to support legacy excel format.
Solved! Go to Solution.
Thank you.. It worked. But can you please explain what will the '$' make difference?
The $ indicates to Excel that you are specifying a sheet and not something else like a named range. The $ ensures that data gets written to the sheet.
Good to know.. Thank you Sydney!
An absolutely huge thank you! I've been trying so many work arounds to try and pull in specific sheets from files whose complete filepaths are unknown e.g.
Passing string variable to dynamic input
"C:\Placeholder\" +DateTimeFormat([InputDate],%y%m%d)+ "\Example *"
using * wildcard as the end of file name unknown (it uses an hour minute second timestamp which is the bane of my existence). Adding |||Targetsheet at the end didn't work but |||Targetsheet$ did! Will look into why later but for now I'm happy with a running workflow so thank you once again!
is there any way to add password and username as an argument to this string probably after thedollar sign eg:
C:/User/Database/my_accessdb.accdb|||Table1$user=kk&pwd=123
Brilliant!
I had the same error and it solved it for me too! Thank you sooooo much