I am stuck with inserting data into my MS Access Database. I already converted the data into cell array but it still returns me the error indicating that I am inputting the wrong data type.

1 次查看（过去 30 天）

Tan Jun Hao 2015-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217657-i-am-stuck-with-inserting-data-into-my-ms-access-database-i-already-converted-the-data-into-cell-ar

评论： Tan Jun Hao 2015-5-21

C = 
      'SGX 8873 K'
>> iscell(C)
ans =
       1
>> datainsert(conn,'VehicleLocation','col2','C')
Error using database/datainsert (line 58)
Input data must be a cell array or numeric matrix.

Been stuck on inserting the data into the database for quite some time now. The input data 'C' is already verified as cell array by the command iscell(C). Anybody got any idea what am I doing wrongly? Thanks.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2015-5-20

Umakant, examine the below:

>> 'ABC'
ans =
ABC
>> {'ABC'}
ans = 
      'ABC'

When you see a string with quotes around it and indented, that is indicating a cell array containing the string; if it were a plain string then it would be displayed without the quote marks or indentation.

Tan Jun Hao 2015-5-20

variable.png

Umakant, I am currently using r2015a.

I have attached a photo of the variable editor, which shows that C is a 1x1 cell.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（3 个）

the cyclist 2015-5-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/217657-i-am-stuck-with-inserting-data-into-my-ms-access-database-i-already-converted-the-data-into-cell-ar#answer_179728

编辑：the cyclist 2015-5-20

Guessing you want to remove the quotes from around C in the datainsert statement. You are trying to insert the single character 'C', rather than your variable C.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Tan Jun Hao 2015-5-20

编辑：Walter Roberson 2015-5-20

C = 
      'SGX 8873 K'
>> iscell(C)
ans =
       1
>> datainsert(conn,'VehicleLocation','col2',C)
Cell contents reference from a non-cell array object.
Error in database/datainsert (line 72)
    insertField = [ insertField fieldNames{i}];  %#ok