I regularly import flatfiles from our network in order dissect, compare and produce reports. The report generator that produces these flat files only create files with a .lis extension. Access only seems to accept .txt extensions. Renaming the original flat file is doable but it does not allow me to import and process it through a macro. I tried using vba to import the file with a .lis extension but it still doesn't work. I have to manually rename the file on the network and then run the macro.
Any help will be greatly appreciated.
Any help will be greatly appreciated.
