jatfill
Registered User.
- Local time
- Today, 00:25
- Joined
- Jun 4, 2001
- Messages
- 150
hello all,
I'm writing a procedure that transfers an error log (the log is in text format) into an Access table, so that users can generate summary reports an analyze generated errors
I've written the import specs, and they work fine.
The only problem is, the error log is written automatically from another application, and is given an extension of .SGL, even though it is a standard text file. The file name varies with each generated log file (except the extension) so the form I built has a file select dialog.
The transfer text process will not recognize the .SGL file, it returns a "file is read only" error... but if I manually rename the file and change the .SGL to .txt, it works fine.
Does anyone know of a way I can either...
a.) automatically rename the selected file & change the extension.
b.) get Access to recognize an .SGL text fileas a valid import format
Thanks in advance!
I'm writing a procedure that transfers an error log (the log is in text format) into an Access table, so that users can generate summary reports an analyze generated errors
I've written the import specs, and they work fine.
The only problem is, the error log is written automatically from another application, and is given an extension of .SGL, even though it is a standard text file. The file name varies with each generated log file (except the extension) so the form I built has a file select dialog.
The transfer text process will not recognize the .SGL file, it returns a "file is read only" error... but if I manually rename the file and change the .SGL to .txt, it works fine.
Does anyone know of a way I can either...
a.) automatically rename the selected file & change the extension.
b.) get Access to recognize an .SGL text fileas a valid import format
Thanks in advance!