Search Results

Search found 3 results on 1 pages for 'user316833'.

Page 1/1 | 1 

• running same query in different databases

  - by user316833

  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?

  Read the article

• importing and appending results of queries from different db in one db

  - by user316833

  I have 1000+ access files. Each file has a query named "overview" that has the same fields in each of the 1000 files. I need to import the results of these 1000+ overview queries into one single access db and append them into one table. Is there an automated way to do this? Thanks very much.

  Read the article

• how to use database name as a value

  - by user316833

  I have more than 1000 access databases with the same table names.Each database has a unique name. In each database, I want to add column to one existing table and populate that new column (all rows in the table would be the same) with the database name. I found the example below - How can I alter this to give the new column the name of the database. ALTER TABLE TestTable ADD NewColumn INT; UPDATE TestTable SET NewColumn = 0;

  Read the article

1