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
