Science topic
Microsoft Access - Science topic
Explore the latest questions and answers in Microsoft Access, and find Microsoft Access experts.
Questions related to Microsoft Access
How can I export a list of the research linked to a Project, in the same way as using 'export as CV' on a Profile?
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.
- 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);
Best regards,
Margarita Fatianova.
Access has the capacity of being used as a database, but I request information on the additional feature of circulation control.
