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

<markr***@gmail.com> wrote in message
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.

<markr***@gmail.com> wrote in message
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


<markr***@gmail.com> wrote in message
Show quoteHide quote

Reporting ASP
converting rtf to JPEG?
ASP position question
ASP error in pm.asp line 192 (second try - Please help)
Turn Calculated Field Results into Currency