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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Question 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.

  2. #2
    Join Date
    Dec 2004
    Location
    México DF
    Posts
    127
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center