Pages: 1

ODBC driver. Excel client

Posted by Oleg Solovyev on Feb 21, 2010
SAS ODBC connection schema ODBC (Open DataBase Connectivity) is a technology to connect something (called client) to a database. It is widely used to download data to SAS from other DBs. But one can also use

ODBC to download data from SAS. For instance one can connect Excel to SAS to copy data from SAS into Excel skipping temporary CSV files or to use Excel as a DWH client.

There is an instruction to configure SAS ODBC driver available on SAS.com. We will follow the instruction and connect Excel to SAS.

more »

Pages: 1