468,107 Members | 1,547 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

whats the best way of migrating data (MS Access)

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

Dec 15 '05 #1
4 1266
<ma******@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
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.
Dec 15 '05 #2
no its ongoing - i want to 'import' data from different sources as the
data i get supplied in is always in a different schema.

Dec 15 '05 #3
<ma******@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
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.
Dec 15 '05 #4
copy and paste from within access... or write a lot of code

those are really the choices
<ma******@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
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

Dec 15 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Bill Willyerd | last post: by
reply views Thread by Manystrengths | last post: by
1 post views Thread by Paul Aspinall | last post: by
reply views Thread by Bernie Beattie | last post: by
11 posts views Thread by sanders_mike_newsgroups | last post: by
13 posts views Thread by G | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.