whats the best way of migrating data (MS Access)

[markrush]

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

 

[McKirahan]

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

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.

 

[markrush]

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

 

[McKirahan]

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

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

 

[Kyle Peterson]

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

those are really the choices