Using Excel as a database
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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:
0 commentaires
Réponse acceptée
Varun Bhaskar
le 13 Août 2015
Hello,
The script attached illustrates how to fetch data into MATLAB from an Excel database. It has explanatory comments.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!