I am a contractor working with a client using OnTime 2004 Web Edition.

For tracking certain metrics, I cut-and-paste the Defects list into Excel and generate PivotTable Charts.  Because of the way the cut-and-paste technique is working*, this is very time consuming, taking over 30 minutes for less than 300 Defects to be pasted into an Excel sheet.

 I am wondering if there is anyway to directly access the database being used by OnTime (coworkers and project manager don't know) so that I can have Excel directly point there, instead of me doing it by hand?

Using the Web Query tool in Excel is not an option since I can't do more than one page at a time and I'm limited to viewing 100 at a time.

Upgrading is also out the window since we don't have the resources, or time.

 --

I can't cut-and-paste directly into Excel since it copies the Action column, which cannot be turned off and while the column can be deleted, the icons stay, causing memory/bloat problems.  I can't cut-and-paste directly into notepad/wordpad, since the column delimiter is a space, not a tab, and will cause import problems in Excel (not-fixed width).

The workaround is to cut-and-paste no more than 50 rows at a time into Word, delete the Actions column, copy the remaining table into Excel, clear the Clipboard, rinse and repeat.  Very time consuming...