« Return to the blog entry
Jake,
Clicking on the Export to excel link will launch an Excel sheet with the data only in case of Excel 2000 and above.
For Excel 97, it will ask you to download the text file.
Download the text file and place it in C:/apps/Microsoft Office/Queries/ or whatever the location of 'Microsoft Office/Queries/' is !
You need to open Excel 97 and then click on Get External Data - > Run Web Query and select the iqy file.
Jake,
Clicking on the Export to excel link will launch an Excel sheet with the data only in case of Excel 2000 and above.
For Excel 97, it will ask you to download the text file.
Download the text file and place it in C:/apps/Microsoft Office/Queries/ or whatever the location of 'Microsoft Office/Queries/' is !
You need to open Excel 97 and then click on Get External Data - > Run Web Query and select the iqy file.