Very Computer

.
I want to create a new table, an exact copy of the existing table,
without
data. In Oracle I could do this
by
    Create table tablename as(select * from oldtable where 2=1)
How can I accomplish this in Access 2000 and using ADOX  at runtime.
Thanks.

Quote:> .
> I want to create a new table, an exact copy of the existing table,
> without data. In Oracle I could do this by
>     Create table tablename as(select * from oldtable where 2=1)
> How can I accomplish this in Access 2000 and using ADOX  at runtime.

Try something along the lines of
http://www.able-consulting.com/ADOX_Faq.htm#Q3

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

I am aware of Creating a New table and appending all the columns. But that
is not exact image of the
existing table which I want to copy. Each column's  properties need to be
defined separately. What I want to know is, if there is a short cut SQL
statement that can do this job, like I do in Oracle.
Thanks.
ram

Quote:> I am aware of Creating a New table and appending all the columns. But that
> is not exact image of the
> existing table which I want to copy. Each column's  properties need to be
> defined separately. What I want to know is, if there is a short cut SQL
> statement that can do this job, like I do in Oracle.

Use the SELECT INTO sql command

e.g.
'********
    Dim oConn As ADODB.Connection

    Set oConn = New ADODB.Connection
    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=.\AdvWorks.mdb;"

    oConn.Execute "SELECT * INTO temp2 FROM Customers WHERE 1=2"
'********

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com