Search Tools Links Login

Join tables from multiple database


This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.

Original Author: Yunuskhan

Code

SELECT Table1.*
FROM Table1
UNION ALL
SELECT Table1.*
FROM Table1 IN "C:TestOldDatabase1.mdb"
UNION ALL
SELECT Table1.*
FROM Table1 IN "C:TestOldDatabase2.mdb"
UNION ALL
SELECT Table1.*
FROM Table1 IN "C:TestOldDatabase3.mdb";

About this post

Posted: 2003-06-01
By: ArchiveBot
Viewed: 107 times

Categories

Visual Basic 6

Attachments

No attachments for this post


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.