Posted on: 8/5/2013 5:35:14 PM | Views : 600

I have been having a very frustrating time trying to connect to a localDB database from Excel VBA.

I have created a database using Visual Studio 2012 Express and in the IDE the database seems fine. I can create data and query it without problem.
In Visual Studio the Connection Properties windows shows:
Name:                     D:\FISKDEV_EXCEL\FISKDBSOLN\FISKDBSOLN\FISKDB.MDF
Connection String:    Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\FiskDev_Excel\FiskDBSoln\FiskDBSoln\FiskDB.mdf;Integrated Security=True
Provider:                 .NET Framework Data Provider for SQL Server
Primary File Path:     D:\FiskDev_Excel\FiskDBSoln\FiskDBSoln\FiskDB.mdf

I then try to connect to the automatic inst ...

Go to the complete details ...