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

"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.
> >> Is it possible to do the same thing with one command for Oracle?
> >
> >Yes.
> >
> >create table <new_table> as select * from <old_table>;
>
> Sounds like this should be the basis of the solution.
>
> Only problem here that I can see is how to get <old_table> from VB to be
> recognised by Oracle. Normally in VB one does something like this:
>
> strSQL = "create table <new_table>"
> dbtemp.Execute strSQL, dbFailOnError
>
> So, all parts of the SQL string have to be string values or be converted
to
> string values...not sure I can do that with a whole table.
>
> Dave

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.

VB isn't really involved except to send the command to Oracle.

Jim Received on Sun Apr 09 2006 - 10:31:48 CDT