Export matrix to Microsoft Access. Error using database / insert
古いコメントを表示
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);
採用された回答
その他の回答 (1 件)
カテゴリ
ヘルプ センター および File Exchange で Matrix Indexing についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!