Access/VB6 - copy a table structure to a new table

[Raffles666]

This one has me stumped. I have an Access database that contains a table (so far, so good).

I want to copy that table to a second table - but only the structure.

Is there a way using NOTHING but VB6 code to do this?

Connection methods are not a problem - as this is a fresh 'program'.

Thanks


Old school Alchemy engineer - trying to keep up with the times

http://www.DataVox.co.uk

"What do you mean - it wasn't broke until I fixed it?

 

[SBerthold]

SELECT * INTO NewTable FROM OldTable WHERE 0=1

 

[SBerthold]

Oh yes, you may lose the indexes when doing this.

It may be more useful to use the DAO TableDef and Indexes to build the table, or use ADOX.