Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19122

Microsoft Access Output : Provide ability to write to Access 2007-2016 file format.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: Unknown
    • Resolution: Unresolved
    • Affects Version/s: 8.3.0 GA, 8.3.0.8 GA, 9.1.0 GA, 9.1.0.2 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Currently, it is possible to write to .accdb file extension using Microsoft Access output step. This file format i.e., accdb extension was released as part of Access 2007 release. However, when we write to this file format and open the Access database using Microsoft Access, the title still shows "Access 2000 file format", even though the extension is .accdb.

      For testing puposes, I created a template db directly in Microsoft Access Input, saved with .accdb extension and reopned the same database. I did not see "Access 2000 file format" in the title section of Access. This happens only when we try to output to accdb file from Spoon. Customer requests ability to write to a proper Access 2007-2016 File format when using Microsoft Access Output.

        Attachments

        1. 2000FileFormat.PNG
          2000FileFormat.PNG
          46 kB
        2. AccessOutput.ktr
          14 kB
        3. testaccess.accdb
          200 kB

          Activity

            People

            Assignee:
            project admin Triage
            Reporter:
            nprakash Nikhil Prakash
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: