Matlab Database toolbox - Excel

Viral Solanki

2015 2 4

0 个回答

4 次查看（30 天）

0 个投票

I got the database toolbox for R2012b, but I can't seem to connect to any database. I don't get any errors. I want to start off simple with an excel connection using database toolbox. Does anyone know how to establish a connection using database toolbox to a excel spreadsheet?

I can't find it anywhere in the documents.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Viral Solanki 2015-2-4

在 MATLAB Online 中打开

Hello Geoff,

That's the issue. I have no idea on how to start the code to establish a connection to excel via database toolbox.

This is the code I use to connect to Access, but even that doesn't seem to work. When I use the following code for access and use the function isconnection, it returns false.

Access Database code:

dbpath = ['Z:\NBush Files\Holdings Files.mdb'];
url = [['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ='] dbpath];
cone = database('','','','sun.jdbc.odbc.JdbcOdbcDriver', url);