Forum Discussion
[DataFormat.Error] The file name is longer than the system-defined maximum length
- 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.txtThis 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.accdbRegards
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.
Hello Rudz
I had the same issues. When your folders containing zip.files then things got nasty. So it's difficult to use Power Query on a big drive to search for files.
My work around was always to run a makro in Excel, that writes me the file names in a table. Then I used Power Query to access to the content of this files
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy