losing data when analyzing queries with excel

[jamccarley]

Whenever I use the "Analyze It with Microsoft Office Excel", I sometimes lose
data in some of my records. It seems random and I was wondering if it is in a
setting or if it is just a flaw that I have to live with.

Thanks
Josh

 

[Tom van Stiphout]

On Tue, 28 Apr 2009 01:43:02 -0700, jamccarley

You're saying: I have 100 records in my table. I use the Analyze
feature. Immediately thereafter I have 99 records in my table.

That seems hard to believe.
One thing you need to do is regularly compact your database to make
sure you don't have a corruption. But otherwise, develop a
reproducible scenario and people would be very interested.

-Tom.
Microsoft Access MVP

 

[jamccarley]

I compact and repair on a daily basis. I don't lose records, i lose data.
For example, a feild contains the sentence "The quick brown fox jumps over
the lazy dog." when I throw this data in to excel, the sentence would be "
The quick brown fox jumps ov" and it would just end like that. All the fields
are set as memo and there is no set number of characters that it stops on,
but it does look like it happens only in fields with more than 100
characters, yet not all fields do this.

Josh