Insert Data Into New Table example ODBC to Microsoft Excel file
14 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
- 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 Commenti
Risposte (1)
Monisha Nalluru
il 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:
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!