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:
Connecting MATLAB with MS-ACCESS????

Subject: Connecting MATLAB with MS-ACCESS????

From: Alok

Date: 24 Mar, 2010 18:01:23

Message: 1 of 3

Hello all !!
I am a first time user of MATLAB. I want to connect databases created in MS-ACCESS with the MATLAB 7.5 (i.e. i want to import and export the data from and to ACCESS)..i have read the tutorials for DATABASE TOOLBOX and followed the instructions to connect the demo database called "tutorial.mdb".
I have SET UP DATA SOURCE for use with ODBC driver.
but when i try to use the data source that i've SET UP it asks me for a username and password. I am stuck here as it is not accepting blank quotes.
Kindly help by giving a step by step instruction to the problem.

Thanking You

Subject: Connecting MATLAB with MS-ACCESS????

From: Oleg Komarov

Date: 24 Mar, 2010 19:36:04

Message: 2 of 3

"Alok " <
> Hello all !!
> I am a first time user of MATLAB. I want to connect databases created in MS-ACCESS with the MATLAB 7.5 (i.e. i want to import and export the data from and to ACCESS)..i have read the tutorials for DATABASE TOOLBOX and followed the instructions to connect the demo database called "tutorial.mdb".
> I have SET UP DATA SOURCE for use with ODBC driver.
> but when i try to use the data source that i've SET UP it asks me for a username and password. I am stuck here as it is not accepting blank quotes.
> Kindly help by giving a step by step instruction to the problem.
>
> Thanking You

Have you tried:
conn = database('datasourcename','','')
conn.message

Oleg

Subject: Connecting MATLAB with MS-ACCESS????

From: Matt

Date: 24 Mar, 2010 19:56:02

Message: 3 of 3

Hello there,
I originally had the same problem, but I got it to work using
user= Admin
pw = Admin

i.e.
dbconnection=database('database_name','Admin','Admin')

Tags for this Thread

No tags are associated with 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