How do I copy a table from one database to another.

[jv6886]

I have been trying to figure out how to copy a table from one Access database to another in code leaving its entire structure (minus relationships) intact. I tried using the SQL statement

SELECT *
INTO TableName
FROM source

but this only copies the basic data structure (datatype and field size) but no other field or table properties (i.e. Primary Key, Caption, Allow Null, etc.).

Is there a way using ADO.NET to copy an intact table from one database to another?

Thanks,
wcprog