Import text file with extension .bcr

[Dirk]

I cannot import a text file with extention .bcr. I do not want to rename the
file as it is created automatically from a third party system.

How do I add .bcr to the list of text files types?

 

[Douglas J. Steele]

See http://support.microsoft.com/?id=245407 (While the article explicitly
mentions Access 2000, it's applicable to all versions)

On the other hand, you could always rename the file to have a .txt extension
(using the VBA Name statement), import it, then rename it back. If you don't
have sufficient access to rename the file, you might be able to copy it
(using the VBA FileCopy statement), and then delete it when you're done
(using the VBA Kill statement)