Hi I have a website which runs a Java application. This application pull some info from a database and displays it on a webpage (ASP).

When I click the Edit with Microsoft Office Excel or "Export to Excel" it shows in excel as ExternalData1: Getting Data but then an error "This Web Query returned No Data"

I then click Edit Web Query and I see that in the Web Query dialog box it is saying Access Denied for the Website I was at and that then re-directs me to the login page. I can log back in and browse back to the Table I need but it opens this in an external webpage outside of Excel so there appears to be no way for me to Export this data other than Copying it all and pasting, which is quite messy.

Any suggestions?