Como instalar o Microsoft.ACE.OLEDB.12.0?

Question

Como instalo o Microsoft.ACE.OLEDB.12.0 no Ubuntu 16.04? Eu instalei o SQL Server 2017 Express.

insert into EPI_NDC_Product SELECT PRODUCTID,PRODUCTNDC,PRODUCTTYPENAME,PROPRIETARYNAME,PROPRIETARYNAMESUFFIX,NONPROPRIETARYNAME,DOSAGEFORMNAME,ROUTENAME, cast(STARTMARKETINGDATE as datetime) as STARTMARKETINGDATE ,cast(ENDMARKETINGDATE as datetime) as ENDMARKETINGDATE,MARKETINGCATEGORYNAME,APPLICATIONNUMBER,LABELERNAME,SUBSTANCENAME,ACTIVE_NUMERATOR_STRENGTH,ACTIVE_INGRED_UNIT,PHARM_CLASSES,DEASCHEDULE
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=/var/www/epignosis.digitology.co.uk/public_html/protected/uploads/1513350050_ndc_product.xlsx',
'SELECT * FROM [NDC_Product$]')

mensagem:

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

    

Answer 1

Como uma alternativa para transferir dados do Excel para um servidor de banco de dados, eu recomendo dar uma olhada em PHPExcel .