exporting data to excel database

1 次查看（过去 30 天）
Ekemini Stephen
Ekemini Stephen 2011-9-29
I prepared an excel database called 'melvin'. I used this code under GUI pushbutton to export data to 'melvin' but I am having the following error.
CODE
conn = database('melvin', ' ', ' ');
set('Autocommit', on)
fastinsert(conn, '''Sheet$''',
{'Harzards','Lcation','Magnitude','Casualties','Aids','DeathRate'},{handles.edit1,handles.edit2,handles.edit3,handles.edit4,handles.edit5,handles.edit6})
close(conn)
ERROR
Error; use updatable sqrly
Also, is there any code or function i can use to launch Microsoft Excel from MATLAB? Please not as an executable application.
Please help me out, it will be deeply appreciated. Thanks in advance.

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

采纳的回答

Walter Roberson
Walter Roberson 2011-9-29
Are you sure the line isn't
set(conn,'Autocommit', 'on')
If you have not included your actual code above, please edit your actual code in.
Is the actual error perhaps, "Operation must use an updateable query"? If so, then please see http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error

更多回答（0 个）

类别

在 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!

Translated by