exporting data to excel database
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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.
0 commentaires
Réponse acceptée
Walter Roberson
le 29 Sep 2011
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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!