Re: Creating a table while loading data into it - possible?

On Sun, 9 Apr 2006 08:31:48 -0700, "Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote:

>
>"Dave Baker" <newsgroup_poster_at_jodael.com> wrote in message
>news:jb1i329lhui8ovro5n7bunpikp8ieutveq_at_4ax.com...
>> On Sun, 09 Apr 2006 14:13:28 +0200, Moritz Klein
>> <mklein_at_students.uni-mainz.de> wrote:
>>
>> >Dave Baker schrieb:
>> >> I'm using VB to load data from one Access table into a destination
>table.
>> >
>> >> What I want to do now is to make the destination table an Oracle table.

>Not sure I understand your question. If both tables are in Oracle then you
>are just sending Oracle a command that says, create this table based on the
>structure of this other table and populate it with the data from the other
>table.

Unfortunately the "source" table will still be in Access.

Dave Received on Mon Apr 10 2006 - 00:24:50 CDT