Have you considered creating a DTS package to get the data in?

I'm not an expert by any means but what I would have done here is built the following stored procedure and use it to retrieve the event details when needed.

create...