By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,027 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,027 IT Pros & Developers. It's quick & easy.

whats the best way of migrating data (MS Access)

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
<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

P: n/a
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

P: n/a
<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

P: n/a
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.