MATLAB: Using Excel as a database

connection to excel

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

Best Answer

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