Hi all.
I have two access dbs. In the first one, i have a number field with the "precision" of 15. In the second db i got the same data but using sum over the number field. The "precision" is set to 28 automatically.
Now if i try to import that data into excel pivot i get an error "Invalid Character value for cast specification" for the number field in the second db, but NO error for the first db.
I'm guessing that the "precision" may be the actual problem, but i cant change it because access claims that i do not have enough ram to perform that change (lots of data).
Does anyone of you have experience with that error? Maybe even a workaround?
I have two access dbs. In the first one, i have a number field with the "precision" of 15. In the second db i got the same data but using sum over the number field. The "precision" is set to 28 automatically.
Now if i try to import that data into excel pivot i get an error "Invalid Character value for cast specification" for the number field in the second db, but NO error for the first db.
I'm guessing that the "precision" may be the actual problem, but i cant change it because access claims that i do not have enough ram to perform that change (lots of data).
Does anyone of you have experience with that error? Maybe even a workaround?