Hi,
does anyone know how to export a vector to an MS Access (.mdb) file?
Or anyone know a good source to read?
MATLAB: Exporting MATLAB data to .MDB
ms access
Related Solutions
To import data from an '.mdb' file into MATLAB, you can use the Database Explorer app from the Database Toolbox.
https://www.mathworks.com/help/database/ug/databaseexplorer-app.html
There is also a MATLAB File Exchange program called 'msquery' that gives the same functionality.
https://www.mathworks.com/matlabcentral/fileexchange/5660-msquery
In the startUp function of the app, we create a connection to the database and store it in a variable. When the First Name and Last Name values are entered and Save to dB button is clicked. I have defined a SavetodBButtonPushed callback event which will utilize the connection established in the startUp function to write into the database
Some of the useful lines code are:
% Properties that correspond to app components
properties (Access = public) UIFigure matlab.ui.Figure LastNameEditField matlab.ui.control.EditField LastNameEditFieldLabel matlab.ui.control.Label FirstNameEditField matlab.ui.control.EditField FirstNameEditFieldLabel matlab.ui.control.Label SavetodBButton matlab.ui.control.Button end properties (Access = private) username; % Username for database
password; % Password for database
datasource; % For Database
data; %data that would be written using sqlwrite
tableName; %Name of the table in the database
end methods (Access = private) % Code that executes after component creation
function startupFcn(app) %Code for creating a connection to the database
app.datasource = "MSSQLServerJDBCAuth"; % For Microsoft SQL Server Database
% You will need to change it to your username and password of your dB.
app.username = ""; app.password = ""; app.conn = database(app.datasource,app.username,app.password); end % Button pushed function: SavetodBButton
function SavetodBButtonPushed(app, event) app.data = table(app.FirstNameEditField, app.LastNameEditField, 'VariableNames', {'First Name', 'Last Name'}); app.tableName = 'UserInfo'; sqlwrite(app.conn, app.tablename, app.data); endendFor more information please visit:
Best Answer