Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL help
First Use
Features
Advanced
Commands
Dialogs
Menu & Toolbar
Excel Functions
Trouble Shooting
VBA & Macros
SQL*XL
Key Features
Usage
Editions
Customers
Forums
Help
Links
Download
Order
SQL*XL: Database to Excel bridge
litLIB: Excel power functions pack
encOffice: Protect your Excel file easy and safe
Home Products SQL*XL Help Features Connecting

Buy now

Download now

SQL*XL online help

 

SQL*XL: Excel MS Project OLE DB Connection

SQL*XL: Excel MS Project OLE DB Connection
SQL*XL
home

To connect to MS Project using the OLE DB Provider (driver) please follow the procedure below:

Start Excel
Open the Connection dialog: SQL*XL | Connect...
Start the Data Link Properties wizard
 

Data Link Properties
 
Choose the Provider MS Project 9.0 OLE DB Provider
Note that the MS Project Provider is not shown in the screen print above.
Also note that the MS Project Provider will be installed by MS Project. If it is not there, run the MS Project installer again and include more items to be installed "from this computer".
 

 
 
Leave all the details on this page at their defaults. Specify your *.mpp file in the "All" tab as shown below.
 

 
Please return to the "Connection" tab and use the Test Connection button before you continue
 

After connecting to the database once you can reconnect by selecting the connection from the Connection History list and typing the Password.


See also:

SQL*XL ribbon in Excel

Copyright (C) 1995-2007 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap