Importing Multiple Files at the Same Time into Multiple Queries

[Anonymous]

Hi,

I have a folder full of about 30 different files and I would like to make them all part of the same dataset. Is there a way to pull them all in at once, so I have 30 different queries? It seems like the only way is to do them as all one table in one query. I don't want to have to go Get Data and select each file individually, considering they all only contain 1 table. If they were all csv files I could make them 1 workbook, but about half of them are pdf.

Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please refer to this video.

https://www.youtube.com/watch?v=whu1CsoZn1Q