#1 2008-10-02 14:49:59

kschuster
Member
Registered: 2008-09-19
Posts: 11

SQL Server to Access

Tags: [MS Access, mssql]

This should be really simple... newbie here

All I want to do is move sql server tables to access (to start).
I have tMSSqlInput to tMap to tAccessOutput
The Access DB is empty and I have Action on Table set to Create table if not exists.  Action on data = Insert

When I run it I get this error

Starting job PTMS_Sql_To_Access at 07:45 02/10/2008.
Exception in component tAccessOutput_1
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
    at ptms.ptms_sql_to_access_0_1.PTMS_Sql_To_Access.tMSSqlInput_1Process(PTMS_Sql_To_Access.java:2368)
    at ptms.ptms_sql_to_access_0_1.PTMS_Sql_To_Access$1.run(PTMS_Sql_To_Access.java:3396)
Job PTMS_Sql_To_Access ended at 07:45 02/10/2008. [exit code=1]

Any idea?  It seems there is a syntax error in the create table statement.  IF that is really what is going on here, how can I fix it?

Offline

#2 2008-10-02 23:27:44

SMaz
Member
Registered: 2008-04-21
Posts: 186
Website

Re: SQL Server to Access

Personally, I find it easier to just create the table myself using the database.
I've had some similar issues in the past.  Just seems easier to me.

Offline

#3 2008-10-02 23:40:13

kschuster
Member
Registered: 2008-09-19
Posts: 11

Re: SQL Server to Access

I'll test this method.  If this is infact how we need to do this, than this is clearly a bug

Offline

Board footer

Powered by FluxBB