Exporting from SSIS 05 to ACCESS 97

• krypto69

  SSChampion

  Points: 13591

  More actions

  October 29, 2012 at 8:14 am

  #284204

  I have a pckage that imports data from an old Access 97 database.

  It imports fine, but when I export (using export wizard, access) my client program trys to connect and gives the error:

  "Unrecognized database format"

  Can SQL 05 export to Access 97?

  Is there something I can do to get it to recognize the old Access 97 format?

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  October 31, 2012 at 10:51 am

  #1554705

  I think it will likely be a driver issue but honestly have not worked in '97 for a very long time.

  As a workaround, you might try exporting to csv and just have the Access db consume it.