https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-in-4-3-and-ODBC-connectivity/m-p/59297#M6052 Hello, I haven't used EG since verion 2.0! Can the query builder in 4.3 connect to ODBC without having to download the table first?<BR /> <BR /> Thanks,<BR /> Chris Thu, 28 Apr 2011 16:33:51 GMT CPAZ 2011-04-28T16:33:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-in-4-3-and-ODBC-connectivity/m-p/59297#M6052 Hello, I haven't used EG since verion 2.0! Can the query builder in 4.3 connect to ODBC without having to download the table first?<BR /> <BR /> Thanks,<BR /> Chris Thu, 28 Apr 2011 16:33:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-in-4-3-and-ODBC-connectivity/m-p/59297#M6052 CPAZ 2011-04-28T16:33:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-in-4-3-and-ODBC-connectivity/m-p/59298#M6053 Yes, if you use SAS/ACCESS to ODBC to define a SAS library to access the table.<BR /> <BR /> Otherwise, you have to use File-&gt;Open-&gt;ODBC -- and that pulls all of the data into your session via the EG client. That can be slow for large data.<BR /> <BR /> Chris Thu, 12 May 2011 12:53:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Builder-in-4-3-and-ODBC-connectivity/m-p/59298#M6053 ChrisHemedinger 2011-05-12T12:53:43Z