Using Excel as a database

I am trying to connect to Excel from MatLab using an Excel workbook tab as a Database (I don't want to just import/export data from Excel into MatLab).

How do I set up the "connection" parameters for that?.

Below is what it looks like if I connect to Excel from Excel itself using an Excel workbook tab as a Database.

----------------------------------------------------------------

Sub Test_Insert_Value()

Dim Temp_Data As New ADODB.Recordset

Dim S_Statement As String

Dim Conn As New ADODB.Connection

Dim DBPath As String

Dim sconnect As String

DBPath = ThisWorkbook.FullName

sconnect = "Provider=MSDASQL.1;DSN=Excel Files;DBQ=" & DBPath & ";HDR=Yes';"

Conn.Open sconnect

S_Statement = " (SELECT * FROM [Temp_Table]"

Temp_Data.Open S_Statement, Conn

Conn.Close

End Sub

-----------------------------------------------------------------------------

This may be related to the solution:

http://soliton.ae.gatech.edu/classes/ae6382/samples/matlab/excel-2/actx_excel.html

Answer 1

[Varun Bhaskar]

Hello,

The script attached illustrates how to fetch data into MATLAB from an Excel database. It has explanatory comments.

[Michel]

Thanks Varun.