SQL vs VB code to form a new table in same database
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.
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL