Reading Data from Office 365 excel using ADODB & SQL

Question

Hello All

I have an excel sheet (97-2003 version) with test data in it which i used to read for test automation purposes.

I have used ADODB along with SQL to query and retrieve the test data.

This was working fine until our Company upgraded to Office 365.

This change has broken the Test automation Framework that i had designed as it heavily relies on excel.

I do solicit help of experts in this group and request a simple code snippet to query and retrieve data programatically.

Let me know if you can help me.

Note: If this is not a suitable forum for this, let me know the right forum.

Thanks in advance.

regards

Nimith

Answer 1

Hi Nanjunda,

Yes. Please post the issue to our TechNet forum for dedicated help. There’s a category for SQL Server. There are some solved issues about  ADODB & SQL.

Thanks,

Rena

Answer 2

Reena

Thanks for your reply. My issue is with Vb script function connecting to Excel 2016 using ADODB and then use SQL query to retrieve data. VB script function was just fine with Excel 97-2003 version. 

Do you still think the Technetforum that you suggested is the relevent for the issue?

Sorry for the repetition.

regards

Nanjunda

Answer 3

Hi Nimith,

We suggest you post the issue to our TechNet forum for dedicated help. There’s a category for SQL Server.

Thanks,

Rena