MATLAB元胞数组写入Access数据库

function mat2acc(execdata)
%


%Set preferences with setdbprefs.
setdbprefs('DataReturnFormat', 'cellarray');
setdbprefs('NullNumberRead', 'NaN');
setdbprefs('NullStringRead', 'null');
%Using ODBC driver.
conn = database('连接数据库名', '', '');


colnames={'字段1','字段2‘};

% execdata1={char(execdata{1,1}),char(execdata{1,2})};

%写入1

execdata1={execdata{1,1},execdata{1,2}};

%写入2

execdata1={['N',num2str(i)]};

insert(conn,'数据表名',colnames,execdata1)
% insert(conna,'tab',colnames,exdata)
end