We have hundreds of .dta files (data files in text format) that we would like to import into Access. If we first change the file extension to .txt, Access can import it just fine. However, we do not want to change the file extension on these.
Is there a way to let Access realize that these .dta files are .txt files, and have it treat them as such?