S Steve Sep 6, 2004 #1 Before importing a file I would like to change its extension to .txt . Is it possible to do this in Access ? Thanks Steve
Before importing a file I would like to change its extension to .txt . Is it possible to do this in Access ? Thanks Steve
K Ken Snell [MVP] Sep 6, 2004 #2 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.
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.
