Invalid Character value for cast specification

Peni

New Member
Joined
Aug 18, 2005
Messages
26
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?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Peni

New Member
Joined
Aug 18, 2005
Messages
26
I succeeded changing it to 15, but the "invalid bla" error remains the same. Does anyone know another possible errorsource?
 

Peni

New Member
Joined
Aug 18, 2005
Messages
26
It seems to work if i change 'decimal' to 'double'. But again i dont not have enough ram...argh.

Any ideas?
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Strange -- Double takes LESS memory than Decimal. You should be able to convert to Double, unless you have a huge database and not much memory on board.

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top