Forum Discussion

Rudz's avatar
Rudz
Icon for Kudo Collector rankKudo Collector
5 years ago
Solved

[DataFormat.Error] The file name is longer than the system-defined maximum length

I am trying to find all Microsoft Access databases on a drive. The query below works until the path gets too long and then dies with:   [DataFormat.Error] The file name Desk\..._5387851 d-7b20-44f7...
  • PhilipTreacy's avatar
    5 years ago

    hi Rudz 

    Open a command prompt and then run a dir command to search for the files.  Output the search results to a file that you can open in PQ.

    Example command, change the file extension accordingly

     

     

    dir *.accdb /s /b > dbfiles.txt

     

     

    This will give you all files with the extension .accdb in all subdirectories off the directory the command was executed in, and stores the results in the file dbfiles.txt

    Results in the file look like this

     

    d:\main.accdb
    d:\temp\myfile.accdb
    d:\temp\backup\accounts.accdb

     

    Regards

    Phil


    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.