Link to home
Create AccountLog in
Avatar of deplayatrix
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 asp.net 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'";
ASKER CERTIFIED SOLUTION
Avatar of Brad Howe
Brad Howe
Flag of Canada image

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

ASKER

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?

-Hades666
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