Re: HELP: Exporting Data From One Table and Importing to Another

Andy Hardy wrote:

> In article <37EEA3F6.411B94B4_at_prodigy.net>, Michael Greer
> <mgreer942_at_prodigy.net> writes
> >
> >I need to export all of the data from a table in database A to a table
> >in database B. While the table in database B has more columns, it does
> >contain all of the columns necessary to import the database A table
> >data. However, the column names are not identicle. Therefore, I was
> >thinking of using the following process to get this done:
> >
> >1) Use MS Access and ODBC to export the table data from database A.
> >2) Rename the columns in Access to match the column names of the target
> >table in database B.
> >3) Export the data from Access to the target table in database B.
> >
> >Will this work? If not, why? This there a simpler more direct process to
> >do what I need to do?
> >
> >Note: The tables are in different databases but located on the same
> >server if that makes any difference.
> >
> >
>
> Why not just insert using select from one table to the other using a
> database link?

Because I don't know how!!!! This is all new for me. How do I do this?

--
Mike Greer

Explore potential income opportunities with Greer and Associates at http://www.ibocity.com/greeraa. Also, Come visit my digital photography web site along with a lot of other interesting stuff at http://www.greer.simplenet.com. Received on Mon Sep 27 1999 - 02:15:06 CDT