How to insert data in Database MS Access
7 ビュー (過去 30 日間)
古いコメントを表示
Hi MATLAB experts,
What I am trying now is to append data to the end of existing table called 'CashFlows' in MS Access database. I pushed data into the table, using the code below.
colnames = {'Date','IDcode','Inflow','Outflow','Net Money'};
tablename = 'CashFlows';
cash_added =
'12/22/2016' [123] [1000] [-200] [800]
insert(connfof, tablename, colnames, cash_added)
However, by using these above, it doesn't seem working because of 'Net Money' in the colnames even though it is a header.
Thus, I just realized that there should not be any spaces in colnames...
In this situation, do you know what other functions I have to use instead of 'insert' to push/append data since I am not allowed to change the headers (i.e. 'Date','IDcode','Inflow','Outflow','Net Money')???..
Hope I explained the case well.
Thanks for your help in advance.
0 件のコメント
回答 (1 件)
David Barry
2016 年 12 月 22 日
I'm not sure about MS Access but with other database you would usually have to deal with fields that contain spaces but either using quotes or brackets around the name, e.g.
colnames = {'Date','IDcode','Inflow','Outflow','''Net Money'''};
or
colnames = {'Date','IDcode','Inflow','Outflow','[Net Money]'};
What's the error message you get back by the way? This might help us to debug.
2 件のコメント
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!