Insert Data Into New Table example ODBC to Microsoft Excel file
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
- Using MATLAB R2019a
- I am trying to Insert Data Into New Table example ODBC to Microsoft Excel file
- ODBC seems to be properly connected as I am able to sqlread() and update() existing data in tables. Also can read and import through Database Explorer APP Toolbox
- I cannot either append or insert data to the database
- I am following the sqlwrite() documentation and InsertDataIntoNewTableExample.m example, only change:
datasource = 'myDatabaseName'; %line 9
- Error received:
Error using database.odbc.connection/sqlwrite (line 102)
ODBC JDBC/ODBC Error: ODBC Driver Error: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement..
Error in InsertDataIntoNewTableExample (line 29)
sqlwrite(conn,tablename,data)
Any advise onto how to diagnose the issue is appreciated as it seems to be related to the sqlquery code which is not inside MATLAB.
Thanks in advance, best regards.
0 commentaires
Réponses (1)
Monisha Nalluru
le 6 Mar 2020
The reason behind the error may be due to database is read-only and Schema name is case sensitive in MATLAB.
Also refer the following links:
1 commentaire
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!