Hello! Below is the code for the following task:(adsbygoogle = window.adsbygoogle || []).push({});

(!) 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:

- 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).

(?) 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?

- Error using database/insert (line 213) General error
- Error in test_matlab (line 22) insert(conn, 'Rtu', colnames, Q);

- I use matlab version R2014b.
- Below there is an archive with files.
[Код]

- I am using the matlab version R2014b.
- Below 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);

[/ код]

**Physics Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Exporting a matrix to Microsoft Access: Error using database/

Have something to add?

**Physics Forums | Science Articles, Homework Help, Discussion**