Sunday, April 24, 2016

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

Wednesday, February 24, 2016

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

What is success?

The journey of life takes us through varied experiences like landing an admission at a prestigious college, earning a degree, getting hired,...