Hi All,

I have a piece of code that will copy the contents of an Excel Worksheet and Paste it into a Access Database Table.

The Problem that i am having is that it doesnt recgonise the Database File Extention .accdb as i am using Access 2007. Is there a different way of operning these types of Databases?

This is The Code i have Got:

Please Login or Register  to view this content.
The Line it has broblems with is: 

Please Login or Register  to view this content.
Any Help With Solving this will be great.

Thanks