Running a bunch of query on MS SQL database

I have created a VBA loop, and SQL statement is inside the loop. The code runs fine, no issue at all. So this is for workplace task, I have permission to use the data (as I can run query on the database).

But my question: What would IT admin (or database Admin) think of an employee running thousands of query on the database within 20 minutes? Does it matter? Is it a normal thing for employee to do? Do they think the action as some kinds of "database attack"? Or I should intentionally place a few seconds pause before running next query? If I add 3 seconds to each query and there is 1000 query, then it adds additional 3000 seconds (50 minutes) of running time, not a good option too.

Same query, but changing the value for WHERE statement, inside the VBA loop (e.g. For i = 1 to 1000 SELECT *** From Table_name Where Group_number = i )

I was just trying to say running query many times on the database within 20 minutes, to IT admin, each query running may be counted as one query.

Then there could be quite a few millions of records if importing it once, which exceeds excel sheet row limit.

If there is no issue on IT admin end, I will keep current code. Dealing with multiple millions of records will require additional VBA code.

@VAer

Once again, please STOP quoting unnecessarily.

I don't know much about interacting with text file via VBA, so I can do it now.

But it is something I should learn to use VBA on text file.

Any good source to learn the skill set? Such as:

• Export data from MS SQL to text file.
• Look into text file to find some data (basically, how to run SELECT * From *** WHERE *** on text file)?

Edit: I have made a new post (kinda new topic): https://www.excelforum.com/excel-pro...text-file.html

You need to go back and mark all previous threads as solved, please.