Data export excel, SQL queries are not repeated, but appeared when written to excel to repeat, excuse me, this is what circumstance

CodePudding user response:

Error estimation is your code, add a breakpoint or print out to check the results of each step

CodePudding user response:

Is query to the number of the article, first time found out ten thousand, early cycle write excel, wonder is, the duplicate data is also occasionally appear,

CodePudding user response:

I also met, it is strange that I suspect is a network problem, the customer is in the United States, they download will appear this problem, I use the company Intranet, you won't get duplicate data, and they can appear not only duplicate data download, data amount no problem, but will be missing data, and the lack of data will be replaced by duplicate data,