Excel Web query missing data when importing from the query dialog to the sheet


From Excel, after I select Data – Import External Data – New Web Query, I input the web lick and click Go, I can see the result in the Web Query windows. After I click the Import button at the bottom to past in the sheet only few data is copied. I’m missing
about half of the data.

I tried all the possible options and still not able to get my data in Excel.

Any help or advise will be appreciated.

Thank you

Hello BarBen,Thanks for your post.However, for your issue I still feel a little confused, could you please offer me some more details information? What kind of data do you want to import to the Excel? Do you mean you want to import the query results of the work items or something what?And I think you can also get better response on the Visual Studio Tools for Office forum.http://social.msdn.microsoft.com/Forums/en-US/vsto/threadsThanks,Vicky SongPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi Vick,Thank you for your reply.Right, I’m not able to import the Query result to the worksheet. When I click the Import button, only half of the data is pasted on the sheet.I get all the metadata but I’m missing fiew fields like the customer Phone, address…/metadata/rendertime /metadata/rendertime/#agg /metadata/serviceid /metadata/serviceid/#agg /metadata/totalresponsetime /metadata/totalresponsetime/#agg /metadata/totalrowcount /metadata/totalrowcount/#agg /resultset/row/BP_ID /resultset/row/SECTOR_NAME /resultset/row/CUST_CITY /resultset/row/CUST_NAME /resultset/row/CUST_NO /resultset/row/IND_NAME

Hello BarBen,I am sorry I can’t replicate the same issue as yours. I am not very familiar with the usage of the Excel web query. However, if you want to