SQL query to export data to Excel

[Dharmesh]

Hi all,

Hi have a query, was wondering if anyone can help me with this please.
I have set up a skills matrix and each of the resources has one or more
skills assigned (ticked) from the resglobal.

The skills are rated level 1 to level 5………
I was wondering if it is possible to produce an excel spreadsheet showing
all resources and their skills?

Skill 1 etc refers to the different skill subsets such as: C++, MS Excel
etc... and the level for each subset is shown in the grid.

The nearest I could get was to export a resource centre view to excel which
included the multi value field, but where a resource has many skills the
character limit was exceeded and it is not easy to view at all.

I was wondering if there is a SQL query that could get the required view
straight from the database table?

Have you any ideas Appreciate you help on this……….

Kind Regards

Dharmesh

 

[John]

Hi all,

Hi have a query, was wondering if anyone can help me with this please.
I have set up a skills matrix and each of the resources has one or more
skills assigned (ticked) from the resglobal.

The skills are rated level 1 to level 5………
I was wondering if it is possible to produce an excel spreadsheet showing
all resources and their skills?

Skill 1 etc refers to the different skill subsets such as: C++, MS Excel
etc... and the level for each subset is shown in the grid.

The nearest I could get was to export a resource centre view to excel which
included the multi value field, but where a resource has many skills the
character limit was exceeded and it is not easy to view at all.

I was wondering if there is a SQL query that could get the required view
straight from the database table?

Have you any ideas Appreciate you help on this……….

Kind Regards

Dharmesh

Dharmesh,
There are several ways to get Project data into other applications. If
the data is static (i.e. not timephased) a simple export map should do
the trick although there is a 256 character limit on text fields. The
next level of export is through a VBA macro. This gives more flexibility
since the export is not limited to static data and the 256 character
limit on text goes up to 1024, the text wrap limit in Excel, but there
are ways to work around that. The third method is through a SQL query on
the Project database.

I have limited experience with export maps but have done quite a bit of
work with VBA exports. I've never done any SQL queries so the best I can
offer with that approach is to direct you to the info file on the
Project database structure. Look for the projdb.htm file, (or something
similar depending on which version of Project you have), on your hard
drive.

Hope this helps.
John
Project MVP