da connectionstrings.com :

codice:
 HDR=Yes;  
 indicates that the first row contains columnnames, not data

 IMEX=1 
 tells the driver to always read "intermixed" data columns as text

 TIP: 
 SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets