Export Data to Ms Access - HELP!!

5 次查看（过去 30 天）

显示更早的评论

BSantos 2013-10-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/90142-export-data-to-ms-access-help

评论： BSantos 2013-10-14

采纳的回答： Friedrich

在 MATLAB Online 中打开

Hello!!

I have tried many ways/tutorials on how to export data from MATLAB to Ms Access, but so far, I haven't fully succeed. I could export all my dataset into 1 column instead of 1 row.

Could you guys please help me??

Thanks in advance.

Here's my code:

colnames - cell array with Column Names <1 x 44>
data - cell array with data set to export to Ms Access <15 x 44>
handles.DB.con - Database connection object.;
datainsert(handles.DB.con,'databaseTable', colnames, data);

error:

Error using database/datainsert (line 104)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

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

Friedrich 2013-10-14

在 MATLAB Online 中打开

I assume it's related to a column name. Maybe one contains a reserved word. Can you post all the columnnames here? The easiest would be

celldisp(colnames)

BSantos 2013-10-14

What kind of names are reserved? Could a column named "Date" be a problem??

请先登录，再进行评论。

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

采纳的回答

Friedrich 2013-10-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/90142-export-data-to-ms-access-help#answer_99588

编辑：Friedrich 2013-10-14

Hi,

yes DATE is a reserved keyword. For a full list see here. You can stil use it but you should escape any column names which are also keywords or functions. In MS Access it should be [] brackets. So instead of 'Date' use '[Date]' as column name.

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

Friedrich 2013-10-14

编辑：Friedrich 2013-10-14

Maybe there are others? The error is given from the driver directly and not from MATLAB. It must be something with the syntax which MATLAB uses to run the SQL command internally.

Maybe start with a dummy database containing one column name and see if it works. if so add a 2nd column and try again. This will lead to the column name which causes the troubles here.

BSantos 2013-10-14