- What do you connect to?
- Any extra options/filters on the extract?
No obvious reasons. Not unheard of but shouldn't happen.
Have to ask though - which number is correct?
Thanks - connecting to Access DB
No options/filters or fancy stuff....just importing from plain old data tables.
The 7M is correct value
So frustrating ! Perhaps something I'm doing - but hard to tell.
If it's frustrating - file a support ticket and we'll gladly look into that.
Forum wouldn't be a place for this since we'd need to look at logs and your schema.
Shot in the dark:
- how many tables are you joining?
- Are there any foreign keys?
- Are you using "assume referential integrity"?
- What do you get for SUM([Number of Records]) on empty sheet for live and extract?
Again though, support ticket would be faster (just mention me and this post).
Don't you worry, Matt - we'll figure it out!