Difference between FTPS and SFTP

I have seen people get confused between FTPS and SFTP and refer these technologies interchangeably. But the fact is they are not same.   FTPS (commonly referred to as FTP/SSL) is a name used to encompass a number of ways in which FTP software can perform secure file transfers. Each way involves the use of…

2

Querying Excel11 and Excel12 files

An excel11 (.xls) file can be very easily queried using “Jet OLEDB 4.0″ provider. C# snippet code for quering excel11 files is as follows,   String strConn = @”Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample.xls;Extended Properties=Excel 8.0”; OleDbConnection objConn = new OleDbConnection(strConn); DataTable dtObject = new DataTable(); objConn.Open(); OleDbCommand objComm = new OleDbCommand(“select * from [SummarySheet$A48:M500]”, objConn); OleDbDataReader objReader =…

0