March 17, 2015 10:36 AM
Profile: Craig Hatmaker
excel
Create MS Access Database with Just Excel and VBA

We don't need MS Access to create MS Access databases. Excel's VBA can create them. Here is sample code:
Dim oCatalog As Object
Set oCatalog = CreateObject("ADOX.Catalog")
oCatalog.Create "provider='Microsoft.ACE.OLEDB.12.0';" & _
"Data...