Importing Files in XP

[Trish]

We have a program that was developed in 97. You can
import text files into the database, but also change the
extension from .txt to say .CI and it still imported just
fine. Now, however, we have converted the database to XP
and we can no longer import anything that is not a
recognized extension.
Again, it works with normal extensions, but anything out
of the ordinary won't work. And asking the user to change
the extension to something normal is out of the question
because she said she gets confused.

Thanks for any help in advance,
Trish

 

[Ken Snell]

I've seen posts that indicate you can change the Registry so that other
extensions may be used, but this limitation is in current ACCESS versions as
a security measure.

Best workaround from my perspective: export the data to the filename you
want to use, but with a ".txt" at the end of it (e.g., MyFilename.iif.txt).
Then, simply change the name of the file via code after it's been exported
so that you remove the ".txt" extension:
Name "C:\MyFilename.iif.txt" As "C:\MyFilename.iif"

Or, if the filename is in a variable:
Name strFileName As Left(strFileName, Len(strFileName) - 3)