Microsoft.Jet.OLEDB.4.0" has not been registered

I'm trying to import an access database into a sql express database (32 bit system) and get the following error

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

my script is as follows

SELECT *

FROM OPENDATASOURCE(

'Microsoft.Jet.OLEDB.4.0',

'Data Source="k:\armycwy.mdb";

User ID=Admin;Password='

)...CWAM_ROSTER

Anyone got an idea what is wrong?

TIA

Kevin

I noticed you mentioned 32-bit: is everything 32-bit - i.e. tha machine, Windows, and SQL Express, or is something perhaps 64-bit? We saw similar issues if running 32-bit SQL Server/SQL Express on a 64-bit machine (or vice versa).

What is the Windows version - e.g., XP, Winwdows Server 2000, 2003, etc.?

|||

hi kevin,

pleas try downloading and installing the latest driver

found on this site

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Joey