java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.

Oracle Community | user5794396 | 2 years ago
  1. 0

    Reg : Error while using Excel as Target Database

    Oracle Community | 7 years ago | bnjutk
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
  2. 0

    ODI error on execution of interface

    Oracle Community | 7 years ago | Varun Kaushal
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
  3. 0

    ODI error: Executing Interface

    Oracle Community | 7 years ago | Varun Kaushal
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Writing Data into Excel with ODI

    Oracle Community | 2 years ago | user5794396
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
  6. 0

    PROBLEM WITH TRUNCATE EXCEL FILE

    Oracle Community | 7 years ago | bnjutk
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcConnection.prepareStatement
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
      3. sun.jdbc.odbc.JdbcOdbc.SQLPrepare(Unknown Source)
      4. sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(Unknown Source)
      5. sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(Unknown Source)
      5 frames
    3. com.sunopsis.sql
      SnpsQuery.executeUpdate
      1. com.sunopsis.sql.SnpsQuery.a(SnpsQuery.java)
      2. com.sunopsis.sql.SnpsQuery.a(SnpsQuery.java)
      3. com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)
      4. com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
      4 frames
    4. com.sunopsis.dwg
      e.run
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
      4. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
      5. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
      7. com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
      8. com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
      9. com.sunopsis.dwg.cmd.e.i(e.java)
      10. com.sunopsis.dwg.cmd.g.y(g.java)
      11. com.sunopsis.dwg.cmd.e.run(e.java)
      11 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame