I was extracting data from the a SQL server to prepare a Pivot Table based P&L report for my client. During the extraction using VBA ADO, we found that the data was not presented correctly. Initially, I was led in the wrong direction by the vendor. Thanks to MSQuery which can present the records instantly, I was able to identify the cause of the error.

Leave a Reply