hi
Please solve this error ?
I want to read the mdb file and push the data to tables in Sql Server 2005
i am using the code like:
exec sp_linkedserver 'linkedadvisor','Acess','Microsoft.jet.oledb.4.0',@mdbfilepath
or
select * from opendatasource('Microsoft.jet.oledb.4.0','datasource='path')...tbl_name
I am getting an error like "Msg 7303 Level 16, State 1 Cannot initialize the datasoure oblect ole db provider 'Microsoft.jet.oledb.4.0' for linked server "null"
but its working in Sql Server 2008
Tanks & RegardsNarayanan