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

Dave Baker wrote:
> I'm using VB to load data from one Access table into a destination table.
>
> At the moment the destination table is also Microsoft Access, so it's a very
> simple matter of doing this:
>
> SELECT * INTO tblDestination IN "C:\My Documents\RawData1.mdb" FROM tblSource
>
> This command creates an entirely new table (entirely new database too I
> guess) and populates it from an existing table, all with 1 command.
>
> 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? I can easily
> do it the hard way by reading the structure of my source table and creating a
> destination structure then finally populating it, but before getting stuck
> into that I thought I would just ask here if it is easier than that.
>
> Thanks,
>
> Dave

You can do it, as others have said, but of far greater concern is why you think this is a good idea. Using VB to perform DDL is an indication of a very poorly thought out design. Can you explain the business reason?

Also ... look up the word "database" in the Oracle docs at http://tahiti.oracle.com. The word "database" means something very different to Oracle than it does in any Microsoft product.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)