Excel particularity in database

[DimitriLYR]

Hello everyone. I am using an excel file as a database. Everything works correctly !

However, I have a problem :

Every day, I have to replace this file with the same file (same name, same extention)

So I got this error : ERROR [HY000] [Microsoft][ODBC Excel Driver] The external table is not in the expected format.

To solve this problem I have to open the file, then save it and close it again.

Do you know why I have to do this manipulation? Isn’t it possible to use it in Data Base when I copy a file?

Thanks

[Anil_G (Anil Gorthi)]

@DimitriLYR

Are you using copy file activity?

After that to make sure just use a use excel file activity and just save the excel and do nothing inside…

Check if the issue is fixed

Cheers

[DimitriLYR]

I’ll try, I think that will solve the problem. But it’s very annoying…