exporting data to excel database

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.

Answer 1

[Walter Roberson]

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