Can I access Access 2007 database via ole-DB?

V

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.
 
S

SteveM

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

Steve
 
V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top