Changing the extension of a file in Explorer

[Steve]

Before importing a file I would like to change its
extension to .txt . Is it possible to do this in Access ?

Thanks
Steve

 

[Ken Snell [MVP]]

Yes, but not directly in a macro. You must use a VBA function to do this.

Public Function ChangeFilextension(strOriginalPathFileName As String)
Name strOriginalPathFileName As strOriginalPathFileName & ".txt"
End Function

This will append .txt to the end of the filename.

 

[Steve]

Thanks Ken