Create Table with ADO

[harrisw]

Create a Table using VB

How can i create a table using nothing but code.

Thanx

 

[crosmill]

You'd need use SQL and then execute the SQL in VBA

docmd.RunSQL (CREATE TABLE TableName)

 

[Oldsoftboss]

This example creates a table, a couple of fields and sets the autonumber and primary key field.
HTH
Dave

 

[harrisw]

How do I do this using ADO and not DAO?

Many Thanks

 

[Travis]

HOWTO: Create a Table with Primary Key Through ADOX