Unanswered: Extracting from Paradox to Excel Incomplete
I need some help figuring out a problem that seems to only occur when using Windows Professional 2000. I've created a couple of macros on Excel that extract data from Paradox using SQL (I'm using Paradox 7, by the way). For some strange reason, the extracted data is incomplete. For example, if there are 3 purchase orders to one invoice, it captures ONLY the first purchase order. What's even more odd is that these macros run perfectly on Windows 98. I've created a query in Paradox to mirror what's being extracted in Excel to verify my numbers -that's how I know that what's being pulled up is incomplete.
Can anybody give me any suggestions on how to fix this?
I'm not an SQL person (yet), but it would be helpful if you posted the query code. Maybe someone who is more up to speed with SQL can hazard a guess. I'm betting there is some difference in the way SQL behaves in Win2000 as opposed to Win98.