Link to home
Create AccountLog in
Avatar of deplayatrix

asked on

i have problem with oldDB connection with excel file

my code is working fine locally but when i published that code and put it in the server 2008
this code can't read the sheets inside the excel file
i'm using an web application C#

this is my connection string

String connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFile + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
Avatar of Brad Howe
Brad Howe
Flag of Canada image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of deplayatrix


thank you very much yes i installed and its works fine
Ok, good. So what is the error you are receiving back from ASP.NET?

i actually i don't see any error message because in deploy the application in the server
and it wasn't return values once i installed Microsoft Access data components 2010 and remove Microsoft office 2007 its working fine thank you man