ADODB Create New Database from Excel

[Guest]

Is it possible to create a new database from Excel using SQL and ADODB? I
cannot create a connection to a file that is not there.

 

[Guest]

Found a possible solution at
http://msdn2.microsoft.com/en-us/library/aa164898(office.10).aspx
Reading through a LOT of material right now.

 

[Bob Phillips]

'----------------------------------------------------------------
Sub CreateAccessDatabase(DBPath As String)
'----------------------------------------------------------------
Dim oADOCat As Object

Set oADOCat = CreateObject("ADOX.Catalog")

oADOCat.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBPath

Set oADOCat = Nothing
End Sub



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)