ODBC Driver for MSProject


B

burcu

Hi,
Is there an ODBC driver for Ms Project?
Where can I find it?
Cheers,
Burcu
 
Ad

Advertisements

G

Gérard Ducouret

Hello Burcu,
you don't need any specific ODBC driver. you just have to create a reference
on Microsoft ActiveX Data Objects 2.1 Library :
in the VBA Editor :
Tools / Reference...

Then you'll create a connection :

Dim conData As New ADODB.Connection
FILE_NAME = "C:\Mes Documents\MS Project 2K\StockProjets\Projet B.mpp"
conData.ConnectionString = "Provider=Microsoft.Project.OLEDB.9.0;PROJECT
NAME=" & FILE_NAME
..../...

Hope this helps,

Gérard Ducouret
 
Ad

Advertisements

R

Rod Gill

Hi,

2.1 should work, but I recommend updating all PC's using it to at least 2.7.
Search Microsoft.com for MDAC updates, the download is free.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/
 

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