Can I access Access 2007 database via ole-DB?

[vvenk]

Hello:

I am using Access 2007.

I am trying to access an Access 2007 from within Microsoft SQL Server
Business Inteligence Studio.

I do not see a Ole-DB driver that supports Access 2007. If i use OLE-DB
driver for Microsoft Jet 4.0 Engine, the file extension defaults to MDB and
even if I cahnge it to *.accdb, I get errors.

Thanks.

 

[SteveM]

Do a Google on 'oledb access 2007' and you will get lots of information about
this including dowload pages for data providers.

Steve

 

[vvenk]

Steve:

I did find a Ole-DB driver for Access 12 (aka Access 2007) already
installed. Once I used that driver, I was able to access the DB.

Thanks.

venki