Insert Data Into New Table example ODBC to Microsoft Excel file
13 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Carlos Amor-Gonzalez
el 19 de Feb. de 2020
Comentada: Carlos Amor-Gonzalez
el 13 de Mzo. de 2020
- 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 comentarios
Respuestas (1)
Monisha Nalluru
el 6 de Mzo. de 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 comentario
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!