Results 1 to 2 of 2
  1. #1
    KNime is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Apr 2017
    Posts
    1

    Access KNIME integration

    Hi folks,

    Please help me if anybody here knows how to connect to Access db from KNIME,
    I have problem in writing the data back to MS Access database, Please help me.
    I tried to read the data from MS Access DB everything was fine.
    Now when I'm trying to write the data back to the same DB after some transformation, I'm getting this error ERROR Database Writer 2:19 Execute failed: UCAExc:::4.0.1 unexpected token: STATE required: (


    Here I'm attaching the image of the KNIME workflow of what I'm trying to do (And that's how I'm configuring), Please find it.
    I'm sure I have missed something, Please help me correct that.

    Thank you.
    Attached Thumbnails Attached Thumbnails KnimeWorkflow.jpg  

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    This isn't a MS-Access issue, so your best bet is to query the source - http://www.knime.org/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Infopath Outlook Integration
    By vaish in forum Access
    Replies: 1
    Last Post: 11-16-2013, 07:15 AM
  2. access integration help
    By vinwin06 in forum SharePoint
    Replies: 1
    Last Post: 06-19-2013, 04:29 PM
  3. real-time data integration of csv file into access
    By nlsoe in forum Import/Export Data
    Replies: 4
    Last Post: 10-17-2012, 06:57 AM
  4. Access 2007 - Integration with Excel
    By cat713 in forum Import/Export Data
    Replies: 3
    Last Post: 07-27-2012, 01:32 PM
  5. Access integration with word and outlook
    By Abacus1234 in forum Access
    Replies: 0
    Last Post: 11-10-2011, 10:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums