CONVERT MS PROJECT 2007 DATA INTO MS SQL SERVER

[ROHAN.P]

HI ,
I AM DEVELOPING WEB APPLICATION IN C#.NET.
I NEED TO IMPORT DATA FROM MS PROJECT 2007 TO MY DATABASE (MS SQL SERVER).
HOW SHOULD I CONVERT DATA FROM MS PROJECT TO SQL SERVER.
WHAT IS USE OF XML SCHEMA AND XML FILE IN THIS CONVERSION.

PLEASE HELP ME.
REPLY SOOOOON....


THANXXX.

 

[Rod Gill]

Hi,

Use OLEDB calls from Project VBA to write to SQL Server. Using xml you would
need to save as xml then have something read the xml into SQL Server and
most of that data is not useful (EG formatting etc.)

Just a note, please don't use all capitals: It's the equivalent of shouting
and I know that I for one ignored your post for a while because of that.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com