if i have 2 datasources with different table names and column headers
that i want to merge i.e. "ptitle" and "name" whats the best way of
doing this? are there any standard routines or should i use something
intermediary like xml?

mark

<markrush@gmail.com> wrote in message
news:1134646766.752802.28230@z14g2000cwz.googlegro ups.com...[color=blue]
> if i have 2 datasources with different table names and column headers
> that i want to merge i.e. "ptitle" and "name" whats the best way of
> doing this? are there any standard routines or should i use something
> intermediary like xml?
>
> mark
>[/color]

Do you need to do it programmatically via ASP?

If it's a one-time effort you could export both to MS-Excel
then cut-and-paste to achieve the merge then import it
back into your database.

If a different approach is required then tell us more and
include the type of database and it's version.

no its ongoing - i want to 'import' data from different sources as the
data i get supplied in is always in a different schema.

<markrush@gmail.com> wrote in message
news:1134659455.319196.110780@g49g2000cwa.googlegr oups.com...[color=blue]
> no its ongoing - i want to 'import' data from different sources as the
> data i get supplied in is always in a different schema.
>[/color]

I would probably write a script that maps one database table
to the other and reads from the one and inserts into the other.

copy and paste from within access... or write a lot of code

those are really the choices


<markrush@gmail.com> wrote in message
news:1134646766.752802.28230@z14g2000cwz.googlegro ups.com...[color=blue]
> if i have 2 datasources with different table names and column headers
> that i want to merge i.e. "ptitle" and "name" whats the best way of
> doing this? are there any standard routines or should i use something
> intermediary like xml?
>
> mark
>[/color]