Using Excel as a database

2 次查看（过去 30 天）
Michel
Michel 2015-8-11
评论： Michel 2016-3-9
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

请先登录，再回答此问题。

采纳的回答

Varun Bhaskar
Varun Bhaskar 2015-8-13
Hello,
The script attached illustrates how to fetch data into MATLAB from an Excel database. It has explanatory comments.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by