[erlang-questions] Erlang ODBC

Alan Gingras <>
Sat Jan 14 22:19:19 CET 2017


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.:

12> odbc:sql_query( Ref, "SELECT * FROM Sheet1;" ).

{error,{"42S02",-1305,

        "[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."}}

 

Spreadsheet is a single sheet (Sheet1).

 

Have also tried "SELECT * FROM [Sheet1$];" with same result.  Have tried
both without the ';' as well.

 

Any suggestions, ideas or examples would be welcome.  Using excel because I
can download the data as a spreadsheet from the source website.

 

Thanks for any help given.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20170114/a4e05f1f/attachment.html>


More information about the erlang-questions mailing list