March 17, 2015 10:36 AM
Profile: Craig Hatmaker
excel
0 Comments
RSS Feed
Email a friend
Create MS Access Database with Just Excel and VBA
Profile: Craig Hatmaker
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...
0 Comments
RSS Feed
Email a friend
