Searching for a specific file and save the path

[Pirre001]

I want to scan a drive (d:\ etc.) for a particular filename. In each folder I find the file I'm looking for, I want to copy the full path from the root and save it to a text file or in a table in Access.
Ex: D:\folder1\folder2\folder3

I do not know what to do, someone who can help me?

[paulg4ije]

You probably need a recursive search. I hate recursion; my brain is too small to follow the logic but it's often a necessary evil ;-)

Try this:

http://support.microsoft.com/kb/306666

It's a little old but should still be valid. This bit of code probably does all you need:

Sub DirSearch(ByVal sDir As String)
        Dim d As String
        Dim f As String

        Try
            For Each d In Directory.GetDirectories(sDir)
                For Each f In Directory.GetFiles(d, txtFile.Text)
                    lstFilesFound.Items.Add(f)
                Next
                DirSearch(d)
            Next
        Catch excpt As System.Exception
            Debug.WriteLine(excpt.Message)
        End Try
    End Sub

[Pirre001]

Thank you. Yes, it may not be needed more code.

A follow-up question... if I caches up this and also retrieves data from a table in a database that also contains a path and cashing it also. How can I easily compare these two who match each other? Using me of linq? If so, how?

[jmcilhinney]

Thank you. Yes, it may not be needed more code.

A follow-up question... if I caches up this and also retrieves data from a table in a database that also contains a path and cashing it also. How can I easily compare these two who match each other? Using me of linq? If so, how?

It's not clear what you're asking for. Are you saying that you have two lists of file paths and you want to find those that in both lists? In one list and not the other? Something else? Please be CLEAR and SPECIFIC.