Importing a CSV Generated from a Dynamic URL

Hello,
I've used it as a resource as much as I could, but I've hit a wall. I was hoping someone can point me in the right direction.

I've found one solution so far, but I know there has to be a better one.

I need to import a CSV file which is generated from this address:
Example:
http://www.google.com/insights/searc...ent=1&export=2

I'm currently using code along the lines of:

Please Login or Register  to view this content.

But..
(a) It opens a new tab in IE7
(b) It assums control of the 'File Download' window to open the file.

I have also tried:

Please Login or Register  to view this content.

But the file name is not in the URL and thus can not open it.

Does anyone have an idea on how to solve this problem or a prior post they can direct me to?

Thanks a bunch.