Run many large update queries in the right order one at a time possible?

Dr. Logic

Board Regular
Joined
Jul 13, 2005
Messages
218
My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots.

SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are over 20 of them.

Can I make a stored procedure or macro that would run each one one at a time in order so I don't need to sit there and click the button on the next query? (it takes an hour to run all of them).
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
842
Yes, as the video shows.
That is about the only use I make of macroes :D
 

Watch MrExcel Video

Forum statistics

Threads
1,108,525
Messages
5,523,384
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top