SQL vs VB code to form a new table in same database

[ittung]

I am a beginner to wirte a Acess database to convert to Excel by VB.

I want to create a table in the same database, I think it may have two methodes to do this.

1) Use the SQL command (Create Table)

2) Use the VB code (CreateTableDef)
I want to know which is/are work, then which one is better.

Also I hope the expert can give me some example about this title.

I am really appreciate that your help.

[MulaChula]

Hi!

I don't know which one is better. However, I think CreateTableDef is the statement you use when using DAO. If you want to work with ADO, you'll need to use ADOX library. Maybe better and wiser people in this forum can advise wheter to use DAO or ADO+ADOX.

HTH,

mc