I am trying to link a CSV text file table in access 2000. The file has an extension .log which cannot be changed. Access spits its dummy because of the extension. Is there a way around this?!
You can use FileCopy in VB to copy the file at runtime (assuming that you do not want to change the extension on the original file).
Probably you will want to copy the file once manually, link it, then everytime you want to open a new version, use the above to copy and overwrite the previous version.
Thinking aloud here, never actually used it this way but I know FileCopy works great.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.