LocalDB Export to Excel

Question

I collected a bunch of data using my locally developed website. Now I need to analyze the data, but it looks like I cannot find the file .mdffor the LocalDB database that my site uses.

Considering a data connection, he says myusername\localdb#abunchofnonsense.mydomainname.Models.UserDBContext.dbo. The connection string data source=(localdb)\v11.0; initial catalog=mydomain.models.userdbcontext; integrated security=true.

In addition, I use ASP.NET MVC, Visual Studio 2013 and Entity Framework, if that helps.

This is probably quite confusing what I'm trying to do here. I have collected some data and you need to run a logistic regression. Now the question is, how can I connect Excel to this LocalDB so that I can export the collected data?

Answer 1

You can import your tables and LocalDB data directly into Excel using the option "Get external data"> "From other sources" on the "Data" tab in Microsoft Excel (more precisely 2013) - as shown in the following screenshot:

Answer 2

A bit late, but maybe someone can use the answer when I found this thread when dealing with a similar problem:

The problem is that localdb uses a different provider than the "normal" SQL connection. To connect, you must use the "native SQL Server client" (in your case, version 11). The provider must be installed with localdb - if not, you can find it here

Excel " " - " " - " " - - .

( , , ): / "Provider = SQLNCLI11.1" (, )

: Installshield, , Excel.