2 Replies - 387 Views - Last Post: 31 July 2019 - 09:23 AM Rate Topic: -----

#1 DarenR   User is offline

  • D.I.C Lover

Reputation: 634
  • View blog
  • Posts: 4,209
  • Joined: 12-January 10

how do i find what version of excel is in 365

Posted 31 July 2019 - 09:11 AM

i have a project where i must upload excel to a location and then extract the info into a database.

i get the following error:


The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.



so i changed the code behind to say 14

 The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.


here is the code behind

   _excelConString = string.Format("Provider=Microsoft.ACE.OLEDB.14.0;Data Source={0};Extended Properties=Excel 8.0", _filePath)



current ace properties:
14.0.7011.1000
name is office 2010 but i have 365

Is This A Good Question/Topic? 0
  • +

Replies To: how do i find what version of excel is in 365

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15262
  • View blog
  • Posts: 61,166
  • Joined: 12-June 08

Re: how do i find what version of excel is in 365

Posted 31 July 2019 - 09:13 AM

Does it have to be excel, or can you by pass that issue with just a CSV?
Was This Post Helpful? 0
  • +
  • -

#3 DarenR   User is offline

  • D.I.C Lover

Reputation: 634
  • View blog
  • Posts: 4,209
  • Joined: 12-January 10

Re: how do i find what version of excel is in 365

Posted 31 July 2019 - 09:23 AM

wish i could but they demanded excel


i figured it out-- had to set the program to 32 bit in the iis
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1