Choice of Database for smooth data import into Matlab
3 views (last 30 days)
Show older comments
Good Afternoon,
I would like to store my input data in a Database external to matlab. Any recommendation regarding the type of DB (Excel, SQL,...) for which the data import runs best?
I heard the Excel file has to be saved under another file type (.mat?) to be read efficiently in matlab which would be kind of a constraint since any modification of the Excel sheet forces to delete the old .mat file and save a new one...
Thank you!
3 Comments
Accepted Answer
Guillaume
on 19 Mar 2019
While excel can be used as a data source, I would hardly call it a database. Particularly, if you compare it to SQL databases. The database software that is part of Office is Access, not Excel. Databases have many features that excel can't provide. It's not clear whether you need any of them though, so you need to explain better your use case.
I heard the Excel file has to be saved under another file type (.mat?) to be read efficiently in matlab
Huh? Matlab can read excel files directly using xlsread or readtable. There's no set method to convert an excel file into a mat file anyway, so if you were to do that, you'd first have to use one of these two functions.
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!