Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Ryan

Date: 17 Apr, 2014 05:07:11

Message: 1 of 6

So, I’ve been trying to work with the Visual Query Builder (Toolboxes > Database) for some time now. I’m making zero progress here.

I’m trying to import some data from MS Access; simple. In the Visual Query Builder GUI, I click ‘MS Access Database’ and immediately a window pops open and it reads ‘Datasource’. This Window wants me to input a UserName & Password. Well, I don’t have either of these. All I’m doing is trying to import data from a small Access DB, with no UserName or Password whatsoever. Instead of clicking ‘MS Access Database’, if I click ‘Excel Files’, I get exactly the same thing; I get prompted to enter the UserName & Password. I DON’T HAVE THESE!! I CAN’T ENTER SOMETHING THAT I DON’T HAVE. If I click Query > Define ODBC Datasource, it seems like I can setup a new ODBC connection, which presumably, will eliminate the requirement to enter a U & P (which don’t even exist). However, under the ODBC Connections, I only have an option to click ‘Add’ and that opens a Window with SQL Server and SQL
Native Client. If I click this, I’m prompted to enter a server name. That’s fine if I’m pointing to SQL Server, but I’m pointing to Excel & Access; these are files, not servers.

What am I missing here? I’ve seen at least a half dozen demos online where the user clicks Visual Query Builder, then select the data source, and he/she is done in like 10 seconds. I’ve been struggling with this for several days, and I’ve gotten absolutely nothing, whatsoever, to work. I must be missing something really simple. Can someone help me get pointed in the right direction, and get this working.

Thanks!!

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Ryan

Date: 18 Apr, 2014 14:09:08

Message: 2 of 6

"Ryan" wrote in message <linnhv$78c$1@newscl01ah.mathworks.com>...
> So, I’ve been trying to work with the Visual Query Builder (Toolboxes > Database) for some time now. I’m making zero progress here.
>
> I’m trying to import some data from MS Access; simple. In the Visual Query Builder GUI, I click ‘MS Access Database’ and immediately a window pops open and it reads ‘Datasource’. This Window wants me to input a UserName & Password. Well, I don’t have either of these. All I’m doing is trying to import data from a small Access DB, with no UserName or Password whatsoever. Instead of clicking ‘MS Access Database’, if I click ‘Excel Files’, I get exactly the same thing; I get prompted to enter the UserName & Password. I DON’T HAVE THESE!! I CAN’T ENTER SOMETHING THAT I DON’T HAVE. If I click Query > Define ODBC Datasource, it seems like I can setup a new ODBC connection, which presumably, will eliminate the requirement to enter a U & P (which don’t even exist). However, under the ODBC Connections, I only have an option to click ‘Add’ and that opens a Window with SQL Server and SQL
> Native Client. If I click this, I’m prompted to enter a server name. That’s fine if I’m pointing to SQL Server, but I’m pointing to Excel & Access; these are files, not servers.
>
> What am I missing here? I’ve seen at least a half dozen demos online where the user clicks Visual Query Builder, then select the data source, and he/she is done in like 10 seconds. I’ve been struggling with this for several days, and I’ve gotten absolutely nothing, whatsoever, to work. I must be missing something really simple. Can someone help me get pointed in the right direction, and get this working.
>
> Thanks!!



Anyone?? Any idea what may be wrong here? I read through the Database Toolbox - Getting Started instructions. I'm thinking that something is not installed correctly.

Again, in the Visual Query Builder window, I click Query > Define ODBC Data Source, I can see MS Access in the list. However, if I select it, and hit OK, then click Access on the main Visual Query Builder window, I'm prompted for a username and password, which I don't have. It really seems like something isn't setup correctly. Maybe I'm missing a driver, or some such thing. Not sure. Any ideas, anyone?

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Steven Lord

Date: 18 Apr, 2014 16:44:32

Message: 3 of 6


"Ryan " <ryanshuell@gmail.com> wrote in message
news:lirbm4$qge$1@newscl01ah.mathworks.com...
> "Ryan" wrote in message <linnhv$78c$1@newscl01ah.mathworks.com>...
>> So, Ive been trying to work with the Visual Query Builder (Toolboxes >
>> Database) for some time now. Im making zero progress here.
>>
>> Im trying to import some data from MS Access; simple. In the Visual
>> Query Builder GUI, I click MS Access Database and immediately a window
>> pops open and it reads Datasource. This Window wants me to input a
>> UserName & Password. Well, I dont have either of these. All Im doing
>> is trying to import data from a small Access DB, with no UserName or
>> Password whatsoever. Instead of clicking MS Access Database, if I
>> click Excel Files, I get exactly the same thing; I get prompted to
>> enter the UserName & Password. I DONT HAVE THESE!! I CANT ENTER
>> SOMETHING THAT I DONT HAVE. If I click Query > Define ODBC Datasource,
>> it seems like I can setup a new ODBC connection, which presumably, will
>> eliminate the requirement to enter a U & P (which dont even exist).
>> However, under the ODBC Connections, I only have an option to click Add
>> and that opens a Window with SQL Server and SQL Native Client. If I
>> click this, Im prompted to enter a server name. Thats fine if Im
>> pointing to SQL Server, but Im pointing to Excel & Access; these are
>> files, not servers. What am I missing here? Ive seen at least a half
>> dozen demos online where the user clicks Visual Query Builder, then
>> select the data source, and he/she is done in like 10 seconds. Ive been
>> struggling with this for several days, and Ive gotten absolutely
>> nothing, whatsoever, to work. I must be missing something really simple.
>> Can someone help me get pointed in the right direction, and get this
>> working.
>>
>> Thanks!!
>
>
>
> Anyone?? Any idea what may be wrong here? I read through the Database
> Toolbox - Getting Started instructions. I'm thinking that something is
> not installed correctly.
> Again, in the Visual Query Builder window, I click Query > Define ODBC
> Data Source, I can see MS Access in the list. However, if I select it,
> and hit OK, then click Access on the main Visual Query Builder window, I'm
> prompted for a username and password, which I don't have. It really seems
> like something isn't setup correctly. Maybe I'm missing a driver, or some
> such thing. Not sure. Any ideas, anyone?

I'm not familiar enough with Database Toolbox to be able to answer, and I'm
not sure very many (if any) of the other regulars are, so I recommend you
contact Technical Support using the instructions in my signature for help.

--
Steve Lord
slord@mathworks.com
To contact Technical Support use the Contact Us link on
http://www.mathworks.com

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Ryan

Date: 18 Apr, 2014 20:14:10

Message: 4 of 6

"Steven Lord" <Steven_Lord@mathworks.com> wrote in message <lirkqg$mtf$1@newscl01ah.mathworks.com>...
>
> "Ryan " <ryanshuell@gmail.com> wrote in message
> news:lirbm4$qge$1@newscl01ah.mathworks.com...
> > "Ryan" wrote in message <linnhv$78c$1@newscl01ah.mathworks.com>...
> >> So, Ive been trying to work with the Visual Query Builder (Toolboxes >
> >> Database) for some time now. Im making zero progress here.
> >>
> >> Im trying to import some data from MS Access; simple. In the Visual
> >> Query Builder GUI, I click MS Access Database and immediately a window
> >> pops open and it reads Datasource. This Window wants me to input a
> >> UserName & Password. Well, I dont have either of these. All Im doing
> >> is trying to import data from a small Access DB, with no UserName or
> >> Password whatsoever. Instead of clicking MS Access Database, if I
> >> click Excel Files, I get exactly the same thing; I get prompted to
> >> enter the UserName & Password. I DONT HAVE THESE!! I CANT ENTER
> >> SOMETHING THAT I DONT HAVE. If I click Query > Define ODBC Datasource,
> >> it seems like I can setup a new ODBC connection, which presumably, will
> >> eliminate the requirement to enter a U & P (which dont even exist).
> >> However, under the ODBC Connections, I only have an option to click Add
> >> and that opens a Window with SQL Server and SQL Native Client. If I
> >> click this, Im prompted to enter a server name. Thats fine if Im
> >> pointing to SQL Server, but Im pointing to Excel & Access; these are
> >> files, not servers. What am I missing here? Ive seen at least a half
> >> dozen demos online where the user clicks Visual Query Builder, then
> >> select the data source, and he/she is done in like 10 seconds. Ive been
> >> struggling with this for several days, and Ive gotten absolutely
> >> nothing, whatsoever, to work. I must be missing something really simple.
> >> Can someone help me get pointed in the right direction, and get this
> >> working.
> >>
> >> Thanks!!
> >
> >
> >
> > Anyone?? Any idea what may be wrong here? I read through the Database
> > Toolbox - Getting Started instructions. I'm thinking that something is
> > not installed correctly.
> > Again, in the Visual Query Builder window, I click Query > Define ODBC
> > Data Source, I can see MS Access in the list. However, if I select it,
> > and hit OK, then click Access on the main Visual Query Builder window, I'm
> > prompted for a username and password, which I don't have. It really seems
> > like something isn't setup correctly. Maybe I'm missing a driver, or some
> > such thing. Not sure. Any ideas, anyone?
>
> I'm not familiar enough with Database Toolbox to be able to answer, and I'm
> not sure very many (if any) of the other regulars are, so I recommend you
> contact Technical Support using the instructions in my signature for help.
>
> --
> Steve Lord
> slord@mathworks.com
> To contact Technical Support use the Contact Us link on
> http://www.mathworks.com


I figured it out...sort of...

On this link:
http://www.mathworks.com/help/database/ug/microsoft-access-odbc-windows.html

When I click Add (on Matlab > Database Toolbox) I don't have item #6; I can't add an ODBC connection. I have SQL Server; nothing else. That's the whole problem. Somehow, I need to add an ODBC connection, but how do you do that when it doesn't exist?

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Ryan

Date: 18 Apr, 2014 20:44:14

Message: 5 of 6

"Ryan" wrote in message <lis12i$sl9$1@newscl01ah.mathworks.com>...
> "Steven Lord" <Steven_Lord@mathworks.com> wrote in message <lirkqg$mtf$1@newscl01ah.mathworks.com>...
> >
> > "Ryan " <ryanshuell@gmail.com> wrote in message
> > news:lirbm4$qge$1@newscl01ah.mathworks.com...
> > > "Ryan" wrote in message <linnhv$78c$1@newscl01ah.mathworks.com>...
> > >> So, Ive been trying to work with the Visual Query Builder (Toolboxes >
> > >> Database) for some time now. Im making zero progress here.
> > >>
> > >> Im trying to import some data from MS Access; simple. In the Visual
> > >> Query Builder GUI, I click MS Access Database and immediately a window
> > >> pops open and it reads Datasource. This Window wants me to input a
> > >> UserName & Password. Well, I dont have either of these. All Im doing
> > >> is trying to import data from a small Access DB, with no UserName or
> > >> Password whatsoever. Instead of clicking MS Access Database, if I
> > >> click Excel Files, I get exactly the same thing; I get prompted to
> > >> enter the UserName & Password. I DONT HAVE THESE!! I CANT ENTER
> > >> SOMETHING THAT I DONT HAVE. If I click Query > Define ODBC Datasource,
> > >> it seems like I can setup a new ODBC connection, which presumably, will
> > >> eliminate the requirement to enter a U & P (which dont even exist).
> > >> However, under the ODBC Connections, I only have an option to click Add
> > >> and that opens a Window with SQL Server and SQL Native Client. If I
> > >> click this, Im prompted to enter a server name. Thats fine if Im
> > >> pointing to SQL Server, but Im pointing to Excel & Access; these are
> > >> files, not servers. What am I missing here? Ive seen at least a half
> > >> dozen demos online where the user clicks Visual Query Builder, then
> > >> select the data source, and he/she is done in like 10 seconds. Ive been
> > >> struggling with this for several days, and Ive gotten absolutely
> > >> nothing, whatsoever, to work. I must be missing something really simple.
> > >> Can someone help me get pointed in the right direction, and get this
> > >> working.
> > >>
> > >> Thanks!!
> > >
> > >
> > >
> > > Anyone?? Any idea what may be wrong here? I read through the Database
> > > Toolbox - Getting Started instructions. I'm thinking that something is
> > > not installed correctly.
> > > Again, in the Visual Query Builder window, I click Query > Define ODBC
> > > Data Source, I can see MS Access in the list. However, if I select it,
> > > and hit OK, then click Access on the main Visual Query Builder window, I'm
> > > prompted for a username and password, which I don't have. It really seems
> > > like something isn't setup correctly. Maybe I'm missing a driver, or some
> > > such thing. Not sure. Any ideas, anyone?
> >
> > I'm not familiar enough with Database Toolbox to be able to answer, and I'm
> > not sure very many (if any) of the other regulars are, so I recommend you
> > contact Technical Support using the instructions in my signature for help.
> >
> > --
> > Steve Lord
> > slord@mathworks.com
> > To contact Technical Support use the Contact Us link on
> > http://www.mathworks.com
>
>
> I figured it out...sort of...
>
> On this link:
> http://www.mathworks.com/help/database/ug/microsoft-access-odbc-windows.html
>
> When I click Add (on Matlab > Database Toolbox) I don't have item #6; I can't add an ODBC connection. I have SQL Server; nothing else. That's the whole problem. Somehow, I need to add an ODBC connection, but how do you do that when it doesn't exist?


I finally figured it out. I have Matlab 64bit and my version of Office is 32bit. Damn. This link explains it.
http://www.mathworks.com/matlabcentral/answers/22671-matlab-64-bit-access-32-bit

I can link Matlab to SQL Server only; my version of SQL Server is 2012 Developer...64bit...of course.

Thanks.

Subject: How to use Visual Query Builder (Toolboxes > Database)? Trying to get data from Excel & Access.

From: Yair Altman

Date: 19 Apr, 2014 17:17:10

Message: 6 of 6

Rather than using ODBC (which has horrible performance and functionality limitations), consider using a direct JDBC connector. You could then use it to connect to 32-bit apps. Section 2.2 in my Matlab-Java book explains the basics of using JDBC with Matlab.

Yair Altman
http://UndocumentedMatlab.com
Read my Matlab-Java Programming book
 

Tags for this Thread

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us