ODBC Driver for MSProject

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