Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Project & MS SQL Database
- Thread starter aghorbani
- Start date
neilkonitzer
Programmer
In your MS Project Help screen, do a search for SQL Server. I'm running v2002 and two of the three results returned showed me how to save to and read from SQL Server. Neil Konitzer
Freisoft
Freisoft
from MS Project 2000
<file> <save as>
click on <odbc>
Machine data source
<new>
click on system data source
select SQL Server, which is the bottom of the list of options.
It will ask you to fill in:
a. Name of Data Source
b. Description of Data Source
c. Then it will ask you to select which SQL Server via pulldown menu
accept the defaults through the rest and you knopw it worked when you click test data and it tells you it was successful. You only need to set this up once--thereafter, you select it as a machine data source {it will now be on the list}
The helps in both SQL Server and MS Project 2000 are very useful in getting through the process.
<file> <save as>
click on <odbc>
Machine data source
<new>
click on system data source
select SQL Server, which is the bottom of the list of options.
It will ask you to fill in:
a. Name of Data Source
b. Description of Data Source
c. Then it will ask you to select which SQL Server via pulldown menu
accept the defaults through the rest and you knopw it worked when you click test data and it tells you it was successful. You only need to set this up once--thereafter, you select it as a machine data source {it will now be on the list}
The helps in both SQL Server and MS Project 2000 are very useful in getting through the process.
- Status
Similar threads