Microsoft New Excel Engine for .NET

This is a useful tip regarding the usage of Import of Excel Data to .NET.

Currently most of the applications are using the following connection string to connect to the Excel Engine.

Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strFinalSourceLoc & strFileName & ";" & "Extended Properties=Excel 8.0;"

However Microsoft has come with a new Excel Engine called “ACE” which eliminates some of the teething bugs in the Old engine.

Here is the connection string of the same.

"Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & strFinalSourceLoc & strFileName & ";" & "Extended Properties=Excel 12.0;"

Here is the place from where we can download the engine for the above connection to work.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en