exec sp_configure 'show advanced options',1;
reconfigure;
exec sp_configure 'Ad Hoc Distributed Queries',1;
reconfigure;
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Database=C:\telefonos.xlsx', 'SELECT * FROM [Hoja1$]')
Instalar:
Microsoft Access Database Engine 2010 Redistributable
reconfigure;
exec sp_configure 'Ad Hoc Distributed Queries',1;
reconfigure;
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Database=C:\telefonos.xlsx', 'SELECT * FROM [Hoja1$]')
Instalar:
Microsoft Access Database Engine 2010 Redistributable
Comentarios
Publicar un comentario