Home > IT Blogs > Beyond Excel: VBA and Database Manipulation

Beyond Excel: VBA and Database Manipulation:

March, 2015

1
March 17, 2015  10:36 AM

Create MS Access Database with Just Excel and VBA

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker
excel

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

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: