Insert Data Into New Table example ODBC to Microsoft Excel file
13 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
- 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 Kommentare
Antworten (1)
Monisha Nalluru
am 6 Mär. 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 Kommentar
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!