I won't give you an answer that you can cut-and-paste, but the following will point you to your answer. You can create databases and tables with VB6 using ADO or via SQL. The following is for ADO
1) Add to references:
ActiveX Data Objects 2.5 Libary
ADO Ext 2.5 for DDL and Security (ADOX)
2) Use ADOX to create the database if it doesn't exist.
Use ADOX to add an empty table shell to a database.
Use ADOX to add formatted columns to a table.
3) Use ADO to load the table.
I strongly recommend the following reference:
msdn.microsoft.com/library/default.asp? (continue next line)
url=/library/en-us/ado270/htm/ (continue next line)
admscadoasp/reference.asp
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.