Trying to write a simple proof of concept to read things from our sql server database and export them to MS Access, but got hung up on the connection. (ASP.NET 3.5, access 2007).

Looking at the connection string in VS when I hit Open() on my OleDbConnection object:

"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\\t emp\\temp.accdb;Persist Security Info=False;"

throws an OleDbException with the messsage "Could not find installable ISAM".

I've been searching around to no avail; most people's problems seem to be simple typos in the string, which I don't see if I have.

I believe I correctly peeked into the registry and saw Jet 4.0 installed in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\, so I think I'm o.k. there.

Looking in regedit, I see Jet 4.0 under Engines, but under ISAM Formats, I only see Jet 2.x and Jet 3.x.

Is this the problem, that Jet 4.0 isn't there? If so, anyone know how to get it?