Linked table issue
I have a db which needs to use the exported report from a 3rd party application in a query. Every time the 3rd party application runs the report it exports a file to the root of c:, but unfortunately this doc is named .doc even though it is a csv. So, when I try to link to it, it kicks me out, as soon as I rename to .csv it is fine.
It is not practical to rename the file locally, as this file is also used by other applications too. So, does anyone know if there is a way or a setting to allow .doc to be a source for a linked table and if so, how do I do it?