Ir al contenido principal

Entradas

Mostrando entradas de agosto, 2011

SQLExpress Configurar consulas Excel

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