08-05-2014 11:12 AM
Hi,
I have the labview program that open connection with excel work book. It was working all right for long time. Suddenly I am getting the error. I am not sure how to solve it>? I dont know anything about .net .So any help will be great.
I have attache the code as well.
Thanks,
08-05-2014 01:38 PM
Does the Excel file still exist at the original location?
Did the version of Excel get upgraded to Excel 2007/2010/2013 ?
08-05-2014 02:18 PM
Yeah the location is still there. I have excel version 10. I dont think I upgared excel.
You know, I ran the code with labview 2013. I see the error different now. It gives clue related to key . but I dont get it.
08-05-2014 02:20 PM
Some code would be helpful. Otherwise we're all just shooting in the dark.
08-05-2014 02:21 PM
If you are using Excel 2010, then the connection string is wrong. It is meant for Excel 1997 to 2003.
08-05-2014 05:20 PM
I did change the string
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s;Extended Properties=Excel 12.0 xml;
I still see the problem. I have attached my code.