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:
采纳的回答
Varun Bhaskar
2015-8-13
0 个投票
Hello,
The script attached illustrates how to fetch data into MATLAB from an Excel database. It has explanatory comments.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
