Is there any way in 2003 to programatically access the Spreadsheet view for
a list and then write that to an Excel spreadsheet. We have a Work Order
setup that is a modified Issue List but has grown to the point of taxing
performance. I have manually archived older items to a series of
spreadsheets and then programmatically deleted the items from the list. I
would like to do it all programmatically through an application.

I have searched the 2003 SDK but haven't found anything.

I have tried saving the Export to a spreadsheet query as covered at
office.microsoft.com/.../HA011196391033.aspx but that doesn't
get all of the list items it just does Current items. I need to create a
spreadsheet the way you can when you Edit a list in a datasheet.

The export will write all list items in the current view to the
spreadsheet. Once exported, Excel 2003 can sync both ways. This ability
was lost in the RTM version of Excel 2007 but I understand that there is
some kind of update that will restore this functionality.

So, create a list view that has what you want to see in the spreadsheet
and then export it. From that point on, periodically synchronizing the
spreadsheet with the list should do the trick.

I did that initially to pair down the list. We have over 3000 Issues and I
manually created Excel spreadsheets for specific dates and then unlinked them.
Then I wrote an applcation to delete the list items. That took care of the
immediate problem  but the list will grow again and I am looking to automate the
whole process:

Conceptual flow:

1. create spreadsheet for selected items on the server hard drive temporarily.
2. upload upload spreadsheet to Document library on the site.
3. delete the selected items from the list.

Currently, I am reading the list items into a table based on date criteria and
then using the file system to write a .csv file. I was hoping there was
something in the SP Object Model that I could use to get a view of he llist and
then generate the spreadsheet.

All of a sudden our SPPS 2003 Portal stopped responding. first we saw
an error in the browser about cross domain problem  but could not find
anyting in the event logs. we reboot the server and the portal somes
back up but then after a few minutes it stops responding and there
are no error in the event log. The portal will show fine but after a
few minutes if we refresh the page we get prompted for credentials and
the portal stops responding.

We do see a lot of ESENT Event 101 svchost (960) The database engine
stopped. Information messages.

Please try to reboot your index server. Are you using any third party tools
for indexing ??

Also check if there were any UMS errors in the database server.