Hello,

When there is a need to import from other db, i usually use updatable
view, in which before insert trigger do all the job. This is especially
usefull, when importing data with various dependancies to changed
structure, or importing (from paradox or dbase) periodical tables (as
you know dbase apps usually creates periodic tables for each month or
year; something like Transactions2005, transactions200501). Disadvantage
is that you have to do lots and dirty sql programming in the
trigger.Advantage is (after you created really good triggger) you may do
incremental imports, or change triggger later if your structure has been
changed.

Adomas

>
>
>