merge multiple databases
From: DIOS (sindizzy.pak_at_softhome.net)
Date: 05/10/04
- Next message: Michael J. Conroy: "Re: DAMAGE after normal block"
- Previous message: Michael J. Conroy: "DAMAGE after normal block"
- Next in thread: Jim Carlock: "Re: merge multiple databases"
- Reply: Jim Carlock: "Re: merge multiple databases"
- Reply: YYZ: "Re: merge multiple databases"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 May 2004 04:23:16 GMT
I have multiple Access97 databases that i want to merge into one single big
database. I have some ideas on how to do it but would like any suggestions
on doing the mrege more efficiently. Currently i am using a VB app to
connect to
the various databases via DAO. The tables look like so:
tblDrive
--------
DriveID (primary key)
fldTitle
fldDesc
tblFiles
--------
FileID (primary key)
DriveID
fldFTitle
fldFSize
tblSubFiles
-----------
SubFileID (primary key)
FileID
DriveID
Basically each drive has many files and each file has many subfiles. I was
going to iterate through each record in
tblDrive and then do a query with the DriveID and get all proper records
from tblFiles and add those to the new database
with a new DriveID. Then for my tblFiles recordset I was going to perform a
query with the same DriveID and the same
FileID and take those records and add them to the new database. This seems
like rather inefficient to me but i cant
see how to do it in a more elegant manner.
tia
AGP
-- ********************************************************************** Unpak my email address before sending me personal email **********************************************************************
- Next message: Michael J. Conroy: "Re: DAMAGE after normal block"
- Previous message: Michael J. Conroy: "DAMAGE after normal block"
- Next in thread: Jim Carlock: "Re: merge multiple databases"
- Reply: Jim Carlock: "Re: merge multiple databases"
- Reply: YYZ: "Re: merge multiple databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
