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

On Sun, 09 Apr 2006, newsgroup_poster_at_jodael.com 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.

Access can connect to Oracle, so you could use Access to do it.

I would bet, you could connect to Oracle from Access and then get VB to use that connection?

But, Access and Oracle don't just straight out talk to each other. You have to do perform some form of a middle step.

-- 
Galen Boyer