MATLAB Answers

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.

2 ビュー (過去 30 日間)
Tan Jun Hao
Tan Jun Hao 2015 年 5 月 20 日
コメント済み: 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 件のコメント
Tan Jun Hao
Tan Jun Hao 2015 年 5 月 20 日
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
the cyclist 2015 年 5 月 20 日
編集済み: 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 件のコメント
Tan Jun Hao
Tan Jun Hao 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
Thanks for the prompt reply. However, MATLAB still indicates that I am not inputting a cell array data. Any idea how to solve this problem?

サインインしてコメントする。


Walter Roberson
Walter Roberson 2015 年 5 月 20 日
datainsert(conn,'VehicleLocation', {'col2'}, C)
The column names must be cell array of string.
  2 件のコメント
Walter Roberson
Walter Roberson 2015 年 5 月 20 日
Sorry, I do not have that toolbox, so I cannot check the code to see what is happening.

サインインしてコメントする。


Thomas Koelen
Thomas Koelen 2015 年 5 月 20 日
Are you sure you already created a database?
  5 件のコメント
Tan Jun Hao
Tan Jun Hao 2015 年 5 月 21 日
Alright thanks! That solved my problem. But now I am currently stuck at inserting multiple columns of data in one instance. Any ideas?

サインインしてコメントする。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by