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 |
|
juvethski
Starting Member
46 Posts |
 Posted - 2013-05-06 : 10:18:15
|
| Hi,There's a ton of thread all over about the openrowset and tried the solutions but I am still getting this error:The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.I also tried the Access Jet and getting this error:The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.I am using Windows XP and SQL 2008, any help will be highly appreciated.Some of the solutions I tried are from this thread:http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/75a20ddc-ac3f-42c1-99fc-ccfc70a47ae2/~~~~~~~~~~~~~~~~how's your data? |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-05-06 : 13:15:21
|
| What you're trying to do with OpenRowSet? are you trying to read/write data from a flat file using sql server? Can you provide details of what you're trying to perform?CheersMIK |
 |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2013-05-06 : 13:27:45
|
| sorry should have provided those details right away. i was trying to import and xlsx file into a sql table, like this statement below:select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xlsx;HDR=YES', 'SELECT * FROM [Sheet1$]')thanks :)~~~~~~~~~~~~~~~~how's your data? |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-05-06 : 13:36:17
|
| Try saving the ".xlsx" file into ".xls" and then execute the query and see what it says select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')1) Make sure that you've a sheet named in that file as "Sheet1" 2) Make sure that the file is not open during query execution.CheersMIK |
|
|
|
juvethski
Starting Member
46 Posts |
Posted - 2013-05-06 : 13:42:41
|
| thanks for replying. i did try the xls and still got the same error message.~~~~~~~~~~~~~~~~how's your data? |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2013-05-06 : 18:55:42
|
| I believe I have the latest version (Windows XP sp3) which is : 4.0.9511.0Any help will be highly appreciated. Thanks!~~~~~~~~~~~~~~~~how's your data? |
|
|
|
|
|
|
Openrowset problem - Windows XP and SQL 2008