Problems obtaining data

[DajOne]

Access 2000: I create a pivot table from a table (no parameters) and get the error 'Problems obtaining data' in Excel...It reads up to a certain numebr of ercords (11,000-12,000 or so) then stops... I m used to do tables iup to 50,000 lines with no problems...

Look at MIcrosoft Knowledge base 198930 to no avail, my table does not need parameters to work.

Anyone has an idea. I am really stuck as i need to produce this report by this afternoon..

(Bill Gates I got a few chosen words for you)

Thanks!!!!

 

[DajOne]

I found that if you try to export the data that you are trying to use in a pivot table an error file may be created where you may find the cause of the Import Error...

That was my case...

Now why would Access import incorrectly one date field out of 25,000..ummm ... do not know that one...

Thanks to all that thought about my problem...