How to insert data in Database MS Access

Question

Jake 2016-12-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317903-how-to-insert-data-in-database-ms-access

评论： David Barry 2016-12-23

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Barry 2016-12-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/317903-how-to-insert-data-in-database-ms-access#answer_248248

在 MATLAB Online 中打开

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.