SQL Import Wizard to Access Database with password error

199 Views Asked by At

I have an accdb access database (2007-2016 version), I am trying to set up a SSIS package to import data to SQL Server via the SQL Import wizard. It all works fine if the access database doesn't have a password but when encrypting the accdb file it doesn't work. I have tried to set the password in the import process but it doesn't recognise it. Any help?

0

There are 0 best solutions below