View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Creating a Database with VBA


Philip Spitzer wrote:
Can a database be created using late binding with DAO? I havn't been
successful in doing it. If not, can a database be created with ADO?

If so,
what is the code?


Set Cat = CreateObject("ADOX.Catalog")
Cat.Create _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\New_Jet_DB.mdb"

Jamie.

--