ODBC Driver for MSProject

[burcu]

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

 

[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

 

[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/