Converting exponential number to numeric T-SQL

Following query can be used to convert an exponential number to numeric format.

SELECT convert(numeric(38,0),cast('4.102e+011' AS float))

Fixing "The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine."

If you have 64-bit Excel installed on 64-bit Windows 10 and are trying to import Excel data into 64-bit SQL Server, you may run into this error message

"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine."

To resolve this issue, you will need to download "Microsoft Access Database Engine 2010 Redistributable"

After running the installer, the import operation should work.

Reference
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx