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.
--
Adios,
Clay Harryman

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


"Clayman" wrote:

> 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.
> --
> Adios,
> Clay Harryman

'----------------------------------------------------------------
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)

"Clayman" <(E-Mail Removed)> wrote in message
news:09AF3E5C-56C4-4A8A-A176-(E-Mail Removed)...
> 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.
> --
> Adios,
> Clay Harryman