Hi,
I am using the following code to convert Excel work sheet to datataable. It is working in my local machine from code. But after deployment in Windows 2003 server this is not reading .XlSX files. Also, I have Office 2007 and VSTS 2010 in Windows Server. Any ideas on this please.
{
System.Data.
lObjConn.Open();
lObjSheetAdapter =
lObjSheetAdapter.Fill(lDTSheetData);
}
lObjConn.Close();
lObjSheetAdapter.Dispose();
lObjConn.Dispose();