I implemented in Visual Basic for Excel 2010 a retrieval of data from a MySQL database via REST using QueryTables as follows:
With ActiveSheet.QueryTables.Add(Connection:= _
.BackgroundQuery = False
.TablesOnlyFromHTML = True
.SaveData = True
The database log file shows that 132 datasets are send out with items ordered numerically from 0 to 131.
The Excel worksheet shows the following exemplary output:
/item0/@f_1 /item0/@f_2 /item0/@f_3 ... and so on
R4010MP014 n. z. 4016
However, it contains only 101 datasets alphabetically reordered. The remaining datasets 69 to 99 are missing.
I thoroughly searched for the reason for the missing data, how to solve the problem, tried different ideas, but could neither find any report on such a problem nor come up with a solution.
One possibility I found is that the problem might lie with Excel's XML flattener adding #agg columns (?). However, another REST query with the same code to the same database, fewer but larger datasets (so more columns are filled) works properly.
I would greatly appreciate if you could provide me with any clues what the problem might be, how I could check or solve it.
With kind regards