David,
> > > > 1) Is there any way you can easily identify the relevant rows in the
> > legacy
> > > > database and export only those?
>
> I guess I'm unclear as to which table you are
> referring to as the LEGACY table. either way i
> imagine that by looking at a table or VIEW of the pik
> numbers common to both tables is what i need, so yes I
> can get that. in fact i have now. but how can i use
> that table to update the price fields in inventory
No, I'm talking about the database system that is exporting to text. Can you
tell it to export only the rows you need?
--
-Josh Berkus
Aglio Database Solutions
San Francisco