Forum

Notifications
Clear all

Executing multiple queries at once

4 Posts
3 Users
0 Reactions
67 Views
(@stringer47)
Posts: 1
New Member
Topic starter
 

Hi,

I'm using excel for Mac 15.23.* I have hundreds of .txt files that are serving as web queries to bring data into excel.

Currently, I'm executing each query individually (Data > Get External Data > Run Saved Query....) then repeating with the next query, and the next one, and the next one....

Obviously, this procedure is relatively time consuming and I'm wondering if there is a way to execute MANY or even ALL of my queries at once instead of doing them individually as described.

Appreciate the help.

 
Posted : 27/02/2020 12:14 pm
(@catalinb)
Posts: 1937
Member Admin
 

Why not Get Data>From File> From Folder?

Just put all text files in that folder and you will get data from all in a single query.

 
Posted : 27/02/2020 12:24 pm
(@catalinb)
Posts: 1937
Member Admin
 

ops, sorry, it's a mac...

Power Query is not available in that mac version

 
Posted : 27/02/2020 12:26 pm
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi,

I don't know the exact format of your text files but you could merge them all from Terminal then just import 1 file?

Place all the text files in the same folder and create a sub-folder called merge. Open Terminal and navigate to the folder with all your text files. For example if your username is BM and you created a folder called Files on your Desktop you'd type

cd /Users/BM/Desktop/Files

Then type the command

cat *.txt >merge/merge.txt

Regards

Phil

 
Posted : 27/02/2020 10:33 pm
Share: