Re: merge multiple databases

From: Ken Halter (Ken_Halter_at_Use_Sparingly_Hotmail.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 10:46:55 -0700

DIOS wrote:
> The database merge is going to be done completely through code.
> The end user does not even know that that databases are Access97
> databases. I will keep the same table structure in the new database.
> I just want to dump all database records into the new database but because
> some IDs may be the same then i just want to account for that. Again,
> i have a plan but its based on iterating through each record. There should
> be
> an easier way to do this.
>
> AGP

There is no easier way (afaik). How often to you need to do this? If
only once in a while, efficiency shouldn't be an issue. Reliability and
control are far more important (imo) for these 'once in a while'
operations. If you need to worry about over-writing specific records,
there is no better way than to have code look at each record. 

-- 
Ken Halter - MS-MVP-VB - http://www.vbsight.com
Please keep all discussions in the groups..

Relevant Pages
Loading