Access to excel, problem with cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export table from access to excel, values are left in the cells but
when I need to sumarize them the values are not recognized.

Example:
1 1 1 1 and the sum should be 4, but the excel give me the sum
of 0.
But if I rewrite the values in cells it give me correct sum.
I have tables with few thousand rows, so this make me a big problem.

Anybody got some idea?

(please dont mind my English. I know it is not the best)

Thank you all.
 
hi,
I saw nothing wrong with your enlish.
access is downloading the data as text.
how are you downloading? what method? do you have code?
what is the data type in the access table?
HDR
 
Thank you.
First I import tables from excel, then I have to combine them together. No
problem here. Than I make relationship and make a querry. Now when this is
over I analyze it with MS excel.
Now I am comming to my problem. I need to make a sum of some collumns. But
Excel does not recognize some of my entries.
Is there any way to change the data so excel will recognize it?
If I format cells and put number as number or currency it does not do
anything.


Korisnik "HDR" napisao je:
 
try to set the format become
Selection.NumberFormat = "0.00"
after you put the value in it
 
Back
Top