Re: exporting/importing tables

Hi Thomas,

        I don't believe export/import is the best way to effect this even if it does work - which I'll check. You may want to try

        Try:

        insert into schemaA.'y' select * from schemaB.'x';

        Hope this helps. Will get back with results of tests next chance. Greg

Thomas Golob wrote:
>
> Hi all,
>
> is it possible to export the data of a certain table 'x'
> and to import the same data in another table 'y' with the
> same structure?
>
> Thanks in advance
> Thomas
>
> ------------------------------------------------------------------------
>
> Thomas Golob <golob_at_netsolut.com>
> Netsolut
>
> Thomas Golob
> Netsolut <golob_at_netsolut.com>
> HTML Mail
> Eckenheimer Landstr. 449 Work: 069/95421220
> Frankfurt Fax: 069/95421217
> 60435 Netscape Conference Address
> Germany Netscape Conference DLS Server
> --------------------------------------------------------
> [Image]
> http://www.netsolut.com
> http://www.branchenbuch.com
> http://branchenbuch.yahoo.de
> Additional Information:
> Last Name Golob
> First Name Thomas
> Version 2.1
  Received on Thu Jan 08 1998 - 00:00:00 CST