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.
Hi Rudz ,
You can create parameters to save your folder location to search files instead of traversing the whole drive.
Change the source like this:
let
Source = Folder.Files(""&Parameter1),
...
in
...
Refer this simliar issue: Import Folder long path
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.