VBA Text Transfer for files with non standard extensions

[rob0r]

Hello,

I was wondering if anyone could help me with a problem I've been having, and one I'm not sure can be fixed. I have a machine that produces user activity logs that are a flat text file, but with the extension ".log" . The code below will work if I change the extension to .txt, but will not work with the .log file. Is there any way round this?

Thanks in advance for any help,

Rob

Sub transfer()
Dim path As String
path = "c:\log\022009\user_activity.log"
DoCmd.TransferText acImportFixed, "user_spec", "Userlog", path
End Sub

 

[rob0r]

Oh, just for the record, the specification was setup using the .txt file since the import wizard didn't recognise the .log file, hence why I think this might not be fixable.