Oooooooo......!!! I like this one! Thanks for the idea. (Never thought about maybe creating and including a DBC in the export dataset. Duuuuhhhh ... )
(Thunderous applause!)
Thanks Cindy!
>What about:
>
>CREATE DATABASE A:\TempDatabase
>SELECT * FROM MyTable INTO TABLE A:\TempTable DATABASE A:\TempDatabase
>
>Then on the other end,
>
>SELECT * FROM A:\TempDatabase!TempTable
>COPY TO C:\NewTable DATABASE C:\ExistingDatabase
>
>
Ernie Veniegas
Micro System Solutions
... sensible software by design