-2

I am using ADO to connect to EXCEL from 64bit machine by VBScript. The MS Office(2013) is 32bit. The connection string is 

Set objExcel = CreateObject( "ADODB.Connection" )
objExcel.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & myXlsFile & ";Extended Properties=""Excel 12.0;IMEX=1;" & strHeader & """"

And it shows an error: Provider cannot be found. It may not be properly installed error code:800A0E7A

Please help me Thanks in advance.

DON
  • 1
  • 1
  • 1
  • 1
  • 1
    Just look to your right you will see the **Related** list of questions, this question has been answered so many times but OPs don't approve the answer so can't mark this as a duplicate, there are at least two directly related to ACE and 10 altogether about the same subject matter. The likelihood is you are trying to access the 64 Bit provider of ACE where only the 32 Bit one is installed regardless of the OS architecture you should be using `%SystemRoot%\SysWOW64` versions of `wscript.exe` or `cscript.exe` to execute the script and access the 32 bit registry to get the correct provider version – user692942 Feb 02 '16 at 09:48

1 Answers1

-2

kindly refer this tutorial how to use ADO to read and write data in Excel workbooks

https://support.microsoft.com/en-us/kb/278973 https://quicktestprofessional.wordpress.com/2008/02/14/adodb-connection-to-read-data-from-excel-sheet/

Narendra Pandey
  • 377
  • 9
  • 28
  • The issue is bitness architecture *(x86 vs x64)*, this answer is pointless and off the mark. – user692942 Feb 02 '16 at 09:49
  • I already tried those. But doesn't work in my machine – DON Feb 02 '16 at 10:16
  • @DON They won't a lot of them are ancient when CPU architecture was solely 32 bit. Wouldn't recommend any of them now. That support article is copyright 16 years ago. – user692942 Feb 02 '16 at 10:37