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

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 Received on Sun Apr 09 2006 - 08:17:46 CDT