SSIS 05 exporting to ACCESS 97
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?qeqw
October 29th, 2012 10:15am
I think you just do not have the proper [Jet] MS Access driver installed or it was overwritten by a newer office installation, so please refer yourself to http://support.microsoft.com/kb/237575?wa=wsignin1.0Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2012 10:25am
Not sure I follow...
I install the driver and my ssis package will export the mdf in access 97 format?qeqw
October 29th, 2012 10:49am