running same query in different databases

Posted by user316833 on Stack Overflow See other posts from Stack Overflow or by user316833
Published on 2010-04-15T04:34:03Z Indexed on 2010/04/15 5:03 UTC
Read the original article Hit count: 231

Filed under:

query

|

automate

|

multiple

I wrote a query that I want to run in several access databases. I have 1000+ access databases with the same tables (same names, same fields). So far, I have been manually copying this query from a txt file to the sql view in the access query design screen for each database and then run it. I did not need to change the query language - everything is the same for the 1000 databases. Is there a way to automate this?

© Stack Overflow or respective owner

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More

Related posts about automate

Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Use JavaMail to Automate Email Distribution

as seen on Internet.com - Search for 'Internet.com'
Learn the basics of using the JavaMail API to build a Java mail application. >>> More
Use JavaMail to Automate Email Distribution

as seen on Internet.com - Search for 'Internet.com'
Learn the basics of using the JavaMail API to build a Java mail application. >>> More
Automate Your Pen Testing with Fast-Track and Linux

as seen on Internet.com - Search for 'Internet.com'
Automated penetration testing tools are a two edged sword: Learn how to run Metasploit-based Fast-Track on your own network before the black hats do. >>> More
Automate Excel Text Import Wizard?

as seen on Super User - Search for 'Super User'
I receive files on occasion in a fixed width format. I need to import them into Excel but Excel doesn't perfectly pick up the columns. I can do it manually each time with the Text Import Wizard, but I'm wondering if there is a way to create a "text import template" or something similar - since these… >>> More