3 ms·
Excel can use any OLE DB driver or ODBC just fine to access other databases. It's not restricted to Access and SQL Server. From the dated look of the dialog win
by ygra 13y ago
Excel can use any OLE DB driver or ODBC just fine to access other databases. It's not restricted to Access and SQL Server. From the dated look of the dialog windows involved I'd say it's been that way for a long time and isn't new in 2010.
- bkor 13y agoOLAP is not like SQL or ODBC. It shows things in a cube. OP is talking about OLAP, not just SQL/some database (which is of course works perfectly fine). Note: Aside from knowing that OLAP is different, not much practical knowledge.
- ygra 13y agoAh, then I got the wrong idea about them mentioning SQL Server.
- elchief 13y agoI should have said "Excel can only talk OLAP to SQL Server". It can talk ODBC/OLEDB to many databases.