Export matrix to Microsoft Access. Error using database / insert
Afficher commentaires plus anciens
Hello! Below is the code for the following task:
- matrix "Q" with a dimension of 3*2 was obtained using a matrix of cells "A";
- then the matrix "Q" is exported to Microsoft Access with the same dimension (3 rows, 2 columns).
(!) The difficulty is that only the first row of the matrix is written to Microsoft Access (of the three available) and then an error message is displayed:
- Error using database/insert (line 213) General error
- Error in test_matlab (line 22) insert(conn, 'Rtu', colnames, Q);
(?) Tell me, please, how is it necessary to add / correct the code in order to record all three rows of the matrix in Microsoft Access?
- I use matlab version R2014b.
- Above there is an archive with files.
Q=[];
A={1, [3 5 8]} % array of cells
for j=1:2 % matrix column index
for i=1:3 % matrix row index
if j==1
Q(i,j)=A{1,j};
else
Q(i,j)=A{1,j}(1,i);
end
end
end
Q
conn = database('QWERT', '', '');
colnames = {'u1', 'u2'};
insert(conn, 'Rtu', colnames, Q);
close(conn);
Réponse acceptée
Plus de réponses (1)
Margarett Ritisova
le 28 Nov 2018
0 votes
Catégories
En savoir plus sur Matrix Indexing dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!