title: VBA Excel To SqlServer
body: <p>What is the best way to write VBA code to connect to SQL Server 2005 from Excel?</p>
  
  <p>The users of the excel file might run XP, Vista, Win7 and I want to prevent driver installation as much as possible.</p>
  
  <p>My understanding is that XP uses MDAC while Vista/Win7 uses DAC. Does that mean that a reference to MDAC 2.8 will not work on a Vista machine and the other way around?</p>
  
  <p>Will my VBA code work on both if I don't add a reference and use late binding, e.g. CreateObject("ADODB.Connection")?</p>