topic setting up odbc for excel queries in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/setting-up-odbc-for-excel-queries/m-p/46497#M707 I have some .sas7bdat files that i want to access via odbc on windows 7. i downloaded and installered the SAS ODBC drivers. While setting up the driver in the ODBC administrator the driver menu is asking for a server reference? Not sure what this needs to be. I suppose there is another configuration i need to make so i can select something and then have a reference to the .sas7bdat files. Please advise and thank u for responding. Thu, 07 Apr 2011 21:15:04 GMT tony2u 2011-04-07T21:15:04Z setting up odbc for excel queries https://communities.sas.com/t5/Microsoft-Integration-with-SAS/setting-up-odbc-for-excel-queries/m-p/46497#M707 I have some .sas7bdat files that i want to access via odbc on windows 7. i downloaded and installered the SAS ODBC drivers. While setting up the driver in the ODBC administrator the driver menu is asking for a server reference? Not sure what this needs to be. I suppose there is another configuration i need to make so i can select something and then have a reference to the .sas7bdat files. Please advise and thank u for responding. Thu, 07 Apr 2011 21:15:04 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/setting-up-odbc-for-excel-queries/m-p/46497#M707 tony2u 2011-04-07T21:15:04Z setting up odbc for excel queries https://communities.sas.com/t5/Microsoft-Integration-with-SAS/setting-up-odbc-for-excel-queries/m-p/46498#M708 <HTML><HEAD></HEAD><BODY><P>In order to read the .sas7bdat files, Base SAS needs to be installed on the machine (so the driver can invoke PROC ODBCSERV) or files must be somewhere that a SAS/SHARE server can access them.&nbsp; </P><P></P><P>Regarding the local access choice, see the information about the "Startup Parameters" at <A href="http://support.sas.com/documentation/cdl/en/odbcdref/63700/HTML/default/viewer.htm#n170ibo0gfz633n1x7xx5pcxqtas.htm">http://support.sas.com/documentation/cdl/en/odbcdref/63700/HTML/default/viewer.htm#n170ibo0gfz633n1x7xx5pcxqtas.htm</A></P></BODY></HTML> Tue, 02 Aug 2011 16:05:24 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/setting-up-odbc-for-excel-queries/m-p/46498#M708 MikeMcKiernan 2011-08-02T16:05:24Z