How to insert data in Database MS Access

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.

Answer 1

[David Barry]

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.

[Jake]

Hi I tried both, but got this message:

Error using database/insert (line 189) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

[David Barry]

Have you tried datainsert and fastinsert instead of insert?