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

Tony,

Thanks. This is a BIG help as I am very much a novice at this stuff. Database A and B are physically seperate, as you describe in the second scenario. Now some basic questions:

1. How does one export a dmp file?
2. How does one import a dmp file?

Just for my knowledge, if I wanted to import a csv file into a table, what is the SQL syntax for that?

Thanks so much for all of your help. I really need it.

Tony Wang wrote:

>
> If database A and databse B is physically two separate ones that
> you cannot see both in the SQL Worksheet at the same time, then
> I prefer to:
> 1. Export the Tables in A into a dmp file
> 2. Import all the tables into B
> 3. Do the INSERT...SELECT to copy data
> 4. Remove the tables originally in A from B.
>
> Hope this helps,
>
> Tony

--
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:23:54 CDT