<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Fairly new to Erlang and trying to use ODBC to connect to an excel spreadsheet. Connect returns { ok, Ref } but any query seems to fail. I.e.:<o:p></o:p></p><p class=MsoNormal>12> odbc:sql_query( Ref, "SELECT * FROM Sheet1;" ).<o:p></o:p></p><p class=MsoNormal>{error,{"42S02",-1305,<o:p></o:p></p><p class=MsoNormal> "[Microsoft][ODBC Excel Driver] The Microsoft Access database engine could not find the object 'MyTable1'. Make sure the object exists and that you spell its name and the path name correctly. If 'MyTable1' is not a local object, check your network connection or contact the server administrator."}}<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Spreadsheet is a single sheet (Sheet1).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Have also tried “SELECT * FROM [Sheet1$];” with same result. Have tried both without the ‘;’ as well.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any suggestions, ideas or examples would be welcome. Using excel because I can download the data as a spreadsheet from the source website.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for any help given.<o:p></o:p></p></div></body></html>