Insert a ".mdf" database into Access

[Philosophaie]

From Excel VBA, how do you insert a ".mdf" database into Access say "Northwind.mdf".

I tried:

    Dim conn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    conn.Open ConnectionString:="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\path\Northwind.mdf;"
    strSQL = "SELECT * FROM [Customers];"
    rs.Open strSQL, conn
    'code
    rs.Close
    conn.Close
    Set rs = Nothing
    Set conn = Nothing

Is it possible?

[June7]

Never heard of .mdf file extension.

What happens when you run the code - error message, wrong results, nothing?

[Philosophaie]

I know it will not work in this for just looking for some hints to see if it can be done.

Error code:

"Unrecognized database format"

[June7]

Okay, this somewhat explains what an .mdf is http://www.access-programmers.com/file-extensions.aspx

But I have no idea if Access can connect to mdf.

http://www.mssqlcity.com/articles/ad...h_database.htm

[tanvi]

I know it will not work in this for just looking for some hints to see if it can be done.

Error code:

Found a good post on error: "Unrecognized database format"