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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2006-08-17 : 11:04:05
|
| I want to write a script that imports the data from an excel spreadsheet. However, I keep getting the following error:Msg 7403, Level 16, State 1, Line 1The OLE DB provider "Microsoft.Jet.OLEDB 4.0" has not been registered.This is a new area to me, so I was wondering if anybody can explain what the error signifies adn what I can do to rectify the issue. Here is the script:INSERT INTO ref.BranchSELECT ro_no,ro_name,addr_1,addr_2,addr_3,addr_4,addr_5,pcode,phone FROM OPENROWSET('Microsoft.Jet.OLEDB 4.0','Excel 97-2005;Database=C:\stores.xls','SELECT ro_no,ro_name,addr_1,addr_2,addr_3,addr_4,addr_5,pcode,phone FROM [STORES$]')Thanks in advanceHearty head pats |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-17 : 13:02:49
|
| See this thread [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[/url], even if the topic is export to excel. I think "EXCEL 97-2005" must be changed to "EXCEL 8.0".Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
|
|
Importing data into DB from Excel - OpenRowSet