Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leo_zidane
Starting Member
1 Post |
 Posted - 2007-10-31 : 00:32:59
|
| I used sql server to run a query. This query will select everything from the excel file and insert it into the database. Recently i have encountered a problem when inserting into the databaseMsg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 4 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls".Is there any way to solve this error |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Error on inserting data to database via excel