This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 4%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Trying to read an Excel file using "Microsoft Office 12.0 Access Database Engine OLEDB Provider" which was downloaded from https://www.microsoft.com/en-US/download/details.aspx?id=13255.
1) Installed the x64, but OLEDB provider is not showing in the Connection Manager.
2) Installed the 32bit, OLEDB provider is showing in the Connection Manager.
However, it is giving below error and test the connection.
Please advise.
Thanks.
Did you check if the file is valid and can be opened in Excel?
Yes, of course.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
did you force the project to x86?
In the past, "any cpu" or "x86" for the project settings used to work. However, now, by default, VS2019 will run "any cpu" as x64 (and in the past it run as x86.
In effect, you need to "force" the bit size the project runs as, and thus don't use "any cpu", but use and force the proejct to x86.