|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 13th, 2009, 11:43 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
How to connect access 2003 to an mpp file
Is there a simple way of importing data from microsft project to access 2003?
I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L 
|
|
#2
July 13th, 2009, 02:27 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to connect access 2003 to an mpp file
I believe the data was directly available through Data Access Pages, but you
may be able to use ADO to access the OLEDB provider. Have a look at the following article from MSDN: http://msdn.microsoft.com/en-us/libr...ojoledb_topic3 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jeff L" wrote in message ... Is there a simple way of importing data from microsft project to access 2003? I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L
|
|
#3
July 13th, 2009, 03:45 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to connect access 2003 to an mpp file
Still the same problem.
I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider I still cannot link to this from Access via the wizard What do I have to do in Access to get the microsoft project tables? -- Thanks for your help Jeff L "Arvin Meyer MVP" wrote: I believe the data was directly available through Data Access Pages, but you may be able to use ADO to access the OLEDB provider. Have a look at the following article from MSDN: http://msdn.microsoft.com/en-us/libr...ojoledb_topic3 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jeff L" wrote in message ... Is there a simple way of importing data from microsft project to access 2003? I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L
|
|
#4
July 13th, 2009, 05:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to connect access 2003 to an mpp file
I think you have to save the mpp as ms access file
Bre-x "Jeff L" wrote in message ... Still the same problem. I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider I still cannot link to this from Access via the wizard What do I have to do in Access to get the microsoft project tables? -- Thanks for your help Jeff L "Arvin Meyer MVP" wrote: I believe the data was directly available through Data Access Pages, but you may be able to use ADO to access the OLEDB provider. Have a look at the following article from MSDN: http://msdn.microsoft.com/en-us/libr...ojoledb_topic3 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jeff L" wrote in message ... Is there a simple way of importing data from microsft project to access 2003? I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L
|
|
#5
July 14th, 2009, 12:07 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to connect access 2003 to an mpp file
We have a white paper on using Access to report from Microsoft Project. Hope
it is useful http://www.projectperfect.com.au/info_msp_reports.php Neville Turbit www.projectperfect.com.au "Bre-x" wrote: I think you have to save the mpp as ms access file Bre-x "Jeff L" wrote in message ... Still the same problem. I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider I still cannot link to this from Access via the wizard What do I have to do in Access to get the microsoft project tables? -- Thanks for your help Jeff L "Arvin Meyer MVP" wrote: I believe the data was directly available through Data Access Pages, but you may be able to use ADO to access the OLEDB provider. Have a look at the following article from MSDN: http://msdn.microsoft.com/en-us/libr...ojoledb_topic3 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jeff L" wrote in message ... Is there a simple way of importing data from microsft project to access 2003? I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L
|
|
#6
July 14th, 2009, 12:14 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to connect access 2003 to an mpp file
You folks were my next suggestion as you have done quite a bit of work with
Access and Project. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "NevilleT" wrote in message ... We have a white paper on using Access to report from Microsoft Project. Hope it is useful http://www.projectperfect.com.au/info_msp_reports.php Neville Turbit www.projectperfect.com.au "Bre-x" wrote: I think you have to save the mpp as ms access file Bre-x "Jeff L" wrote in message ... Still the same problem. I have found that MSP 2003 has Microsoft project 11.0 OLE DB provider I still cannot link to this from Access via the wizard What do I have to do in Access to get the microsoft project tables? -- Thanks for your help Jeff L "Arvin Meyer MVP" wrote: I believe the data was directly available through Data Access Pages, but you may be able to use ADO to access the OLEDB provider. Have a look at the following article from MSDN: http://msdn.microsoft.com/en-us/libr...ojoledb_topic3 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Jeff L" wrote in message ... Is there a simple way of importing data from microsft project to access 2003? I am trying to extract data from a microsoft project (.mpp) file. I can find instructions for Access 2002 which has a wizard with the option "Microsoft project 10.0 OLE DB provider" This does not appear as an option in the Access 2003 wizard. Do I need an add in? -- Thanks for your help Jeff L
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
