ACCESS: need code to delete files from disk 1

[TeddB]

Help Wanted !!

I have an Access query containing names of thousands of filenames, which need to be deleted from disk.

Can this be done entirely from Access? If so, could you please give me a code example.

Much obliged :->
Ted

 

[ide]

something like this. use the Kill procedure with full path to delete a file.

Sub main()
Dim strPath As String
strPath = "d:\temp\Book13.xls"
Call sbDeleteFile(strPath)
End Sub

Public Sub sbDeleteFile(strFullFilePath As String)
If Dir(strFullFilePath) <> &quot;&quot; Then Kill strFullFilePath
End Sub

 

[TeddB]

ide,

Thanks for the quick response