tag:blogger.com,1999:blog-3257858684531586190.post6286072999318170104..comments2024-02-29T19:57:48.948+05:30Comments on SQLScientist.com: The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.Asif Ghanchihttp://www.blogger.com/profile/07769607380863603617noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3257858684531586190.post-68851318519701506812016-10-08T02:59:34.767+05:302016-10-08T02:59:34.767+05:30Thanks!! I got mine working without going to REGE...Thanks!! I got mine working without going to REGEDIT.Crystalhttps://www.blogger.com/profile/01412214993617311233noreply@blogger.comtag:blogger.com,1999:blog-3257858684531586190.post-60333253835166044132016-01-10T19:27:07.806+05:302016-01-10T19:27:07.806+05:30Please check below things to find the root error.
...Please check below things to find the root error.<br />1) Check if the sheet name is "Sheet1".<br />2) Check if the file exist at the location.<br />3) If it's UNC path, please check if you have enough permission.Asif Ghanchihttps://www.blogger.com/profile/07769607380863603617noreply@blogger.comtag:blogger.com,1999:blog-3257858684531586190.post-5563793165440904582016-01-10T12:26:11.268+05:302016-01-10T12:26:11.268+05:30I followed Your instruction but now when I execute...I followed Your instruction but now when I execute the script with the OpenRowSet function, it shows Followinf Error message<br /><br />Msg 7314, Level 16, State 1, Line 1<br />The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" does not contain the table "Sheet1$". The table either does not exist or the current user does not have permissions on that table.<br />Anonymoushttps://www.blogger.com/profile/05829725312960368475noreply@blogger.com