Hi,
Certain excel source face the below error message when I pass the Worksheet name via a global variable.
"OLE or COM processing error. Please make sure Microsoft Access DataBase Engine is properly installed: <''worksheet_name$'' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.>."
Among 40 excels which are processed properly by passing sheet name via Global variables, 2 of them faced the error.
When I hardcode the worksheet name in the Excel format, then they run fine.
Clueless on how could this happen to few excels alone.
The DS version I use is 4.1 SP2.
If anybody has faced this error, Pls share your solutions.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.