🚀 go-pugleaf

OK, now I saw it. You are using Access.
Have you tried using the "SELECT ... INTO"-statement. With this statement
you can import a whole Table into a new DB.
Greetings,
Didi

"Daniel Stevenson" <d.stevenson@ocreage.com.au> schrieb im Newsbeitrag
news:400222b2@newsgroups.borland.com...
> I'm currently looking into alternate (and hopefully faster) ways of moving
> data from one database to another where the field names are the same in
each
> table and in some situations where some fields are not present within the
> new database.
>
> The original database has tables that are related to one another (ie. are
in
> master/detail relationship) and therefore data integrity needs to be
> maintained
>
> I currently move one record across to the new database at a time, then
check
> all other tables for records that are related to the master record and
copy
> those across before incrementing the master record, therefore keeping all
> the records in their correct relationship.
> I'm finding this method very slow especially with a database holding over
> 50,000 records.
>
> I was wondering if there was a bulk method of copying data or an SQL
method
> that might be faster.
>
> I'm currently using BCB6 with ADO and an Access database.
>
> Thanks
>
>