Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.ClickĬn = New OleDb.OleDbConnection('PROVIDER= 12.0 ' & 'DATASOURCE= ' & TextBox1.Text & ' ' & 'EXTENDED PROPERTIES=EXCEL 12.0 ')Ĭmd = New OleDb. Me.WindowState = FormWindowState.Maximized Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load i get error that microsoft.ace.12.0 is not installed in local machine please guide me how to resolve it. It works fine with ms access file but it does not work with excel file while reading excel file through vb. I am working on windows 8.1 which is 64 bit operating system i have installed 2010 access database engind(32bit) and also install access dataabae engind 2007. See Steps 2 and 3 on the PC or Mac tabs above to help you with the rest of the install process. Select the language and bit-version you want (PC users can choose between 32-bit and 64-bit), and then click Install. x86 platform is selected in vb.net is but my error is not fix To install Office, try signing in directly to the Microsoft 365 Software page instead. I used the same thing which you have suggested i.e. Now you should also ask your customer to reinstall Office as 64bit to keep your 64bit app happy. What about 32bit machine? What if Microsoft Office 32bit version is installed on your 圆4 target machine? Office installs its bit compatible version of ACE and, of course, it is not possible to have 32bit and 64bit of ACE installed on the same machine.

But this could be a nightmare for your deployment scenarios. Of course, another option is to deinstall the 32bit version and install the 64bit version of ACE from hereand then run you application as An圜pu on 64bit systems. If you don't have a specific reason to use An圜pu it is better to stay with x86. If you think that using a 32bit app on a 64bit Operating System is a loss of performance or something to be avoided then think twice and read this reference where the PRO and CONS of An圜pu are critically examined. If the x86 option is not already there, then select NEW, name it x86, Copy Settings from An圜PUand check Create new project platforms The simplest workaround is to change the Target Platform of your application through Visual Studio menu BUILD > Configuration > Active > Solution > Platform > x86 The .12.0 has two different version for 64 and 32bit that cannot be installed together on the same machine. You can use other Office applications such as Excel, PowerPoint, Visio, etc. In this example I’m using Microsoft Word. I will begin by opening any one of the Office applications. We only need to follow these simple step-by-steps to do so: 1. An application executed as 64bit cannot use 32bit drivers (and viceversa). Finding out the 32-bit or 64-bit Office version is very easy. When using the An圜pu target Platform your code will be executed as 64bit code on 64bit systems and as 32bit code on 32bit systems. The problem arises when you have your application compiled for An圜PU Platform, you are running on a 64bit system and the installed ADO.NET provider (Microsoft ACE.OLEDB.12.0) is the 32bit version.

Find which office 32bit or 64bit vb.net