Access 2007 DB import to Integration Services

Hoyt81
Hoyt81 used Ask the Experts™
on
Good Morning,

I am trying to import an Access 2007 (accdb) table into SQL Server Integration services via visual studio. I have had no problem importing 2003 (.mdb) files, and i am unable to save this particular 2007 db as 2003.

How should i proceed?

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
What's the problem you have?
Regards,
Pedro
I believe you will need the version 12 driver. Microsoft.ACE.OLEDB.12.0
Check here:
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
HoggZilla

Author

Commented:
Solid  - required a computer restart, but worked perfectly.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial