ADO and copying tables

[aj]

hi, i was wondering if there was a command i could use in ADO or perhaps some
other technology that would let to copy tables in MS ACCESS or Oracle --
i want ASP to copy a table when a user registers. It seems like ADO command
object only supports insert, delete and update.
thx in advance

[Veign]

The general syntax of the "copy table" SQL is:


SELECT * INTO <Target> FROM <Source>If you need to first create a table,
then use the CREATE TABLE command.Also, check out my SQL Quick Reference
Guide on the Veign website....
-- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples & Sample
Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
<discodude9000@yahoo.com> wrote in message
news:3de2d1e9$1@tnews.web.devx.com...
>
> hi, i was wondering if there was a command i could use in ADO or perhaps
some
> other technology that would let to copy tables in MS ACCESS or Oracle --
> i want ASP to copy a table when a user registers. It seems like ADO
command
> object only supports insert, delete and update.
> thx in advance

[aj]

thx for responding--i should be more specific -- question is can i attach
this sql to an ADO object.command object since the book mentions that it
will work for update, insert and delete operations and doesnt say anything
about copy and create commands. could there be another ADO object that may
do the trick if not..also can this be done using access, if not will it
work in oracle?

"Veign" <NOSPAMinveign@veign.com> wrote:
>The general syntax of the "copy table" SQL is:
>
>
>SELECT * INTO <Target> FROM <Source>If you need to first create a table,
>then use the CREATE TABLE command.Also, check out my SQL Quick Reference
>Guide on the Veign website....
>-- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
>Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples & Sample
>Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
>Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
><discodude9000@yahoo.com> wrote in message
>news:3de2d1e9$1@tnews.web.devx.com...
>>
>> hi, i was wondering if there was a command i could use in ADO or perhaps
>some
>> other technology that would let to copy tables in MS ACCESS or Oracle
--
>> i want ASP to copy a table when a user registers. It seems like ADO
>command
>> object only supports insert, delete and update.
>> thx in advance
>
>

[Veign]

If you executing SQL commands against ADO then excute thenm using the
Execute method of the Connection object...There is no need to use the
command object..

--
Veign
www.veign.com
<<NEW Link200 v2.0.2 Released>> - Bigger, Better, Cleaner!
www.veign.com/download_application.html#Link200
Code Samples & Sample Projects
http://www.veign.com/information/app.../info_app.html
NEW! - Quick Reference Guides
http://www.veign.com/company_store.html
------
"aj" <discodude9000@yahoo.com> wrote in message
news:3de456d5$1@tnews.web.devx.com...
>
> thx for responding--i should be more specific -- question is can i attach
> this sql to an ADO object.command object since the book mentions that it
> will work for update, insert and delete operations and doesnt say anything
> about copy and create commands. could there be another ADO object that
may
> do the trick if not..also can this be done using access, if not will it
> work in oracle?
>
> "Veign" <NOSPAMinveign@veign.com> wrote:
> >The general syntax of the "copy table" SQL is:
> >
> >
> >SELECT * INTO <Target> FROM <Source>If you need to first create a table,
> >then use the CREATE TABLE command.Also, check out my SQL Quick Reference
> >Guide on the Veign website....
> >-- Veignwww.veign.com<<NEW Link200 v2.0.2 Released>> - Bigger, Better,
> >Cleaner!http://www.veign.com/download_applic...ml#Link200Code Samples &
Sample
> >Projectshttp://www.veign.com/information/application/info_app.htmlNEW! -
> >Quick Reference Guideshttp://www.veign.com/company_store.html------"aj"
> ><discodude9000@yahoo.com> wrote in message
> >news:3de2d1e9$1@tnews.web.devx.com...
> >>
> >> hi, i was wondering if there was a command i could use in ADO or
perhaps
> >some
> >> other technology that would let to copy tables in MS ACCESS or Oracle
> --
> >> i want ASP to copy a table when a user registers. It seems like ADO
> >command
> >> object only supports insert, delete and update.
> >> thx in advance
> >
> >
>