pasting query data into excel

  • Thread starter Thread starter Carole
  • Start date Start date
C

Carole

I am trying to paste query data from an Access 2002 file
into an excel 2000 spreadsheet and then doing calculations
(adding a column of numbers) on that data. First excel
wouldn't let me format the cells of the pasted data to
numbers but I think I figured that out, but now it won't
add the column - the total result reads 0 instead of what
it should read.
This only happens when going from Access 2002 to excel and
did not happen until I upgraded from 2000 to 2002.
Previously using Access 2000, I didn't even have to
reformat the cells in excel, it just summed the column for
me.
Any ideas?
Thanks in advance
 
Hi Carole,

I believe that one of the recent Office updates fixed the
problem with numeric date being converted to text when
exported to Excel. This hasn't really been a problem for
me though, because Excel warns me when numeric data is
stored as text (I have Office 2002) so I usually just
select all of the date, click on one of the little
warning symbols, and tell Excel to convert it to a
number. If you don't get these little warning symbols,
you turn them on onder Tools|Options on the Error
Checking tab.

I'm not sure I completely understand your other problem.
It wasn't clear to me whether the total returning 0 was
calculated properly in the query but pasting as 0, or
whether it was just an excel total returning 0. If it is
an Excel total, it sounds like your numbers are still
being stored as text. If it is pasting improperly from
the query, you may want to try right-clicking on the
query in access and choosing "Export" and export the data
rather than copying/pasting.

HTH

-Ted Allen
 
Can't find the tools/options error checking tab - I'm
running excel 2000, so I assume it may not be there and be
a 2002 upgrade. I tried to convert the fields to numbers
in excel, but since my sum (done in excel) is 0 which is
incorrect, I also agree with your statement that excel
still thinks its text. Exporting the data into another
spreadsheet within the worksheet and then copying that
into the proper spreadsheet seems to work as per your
other suggestion.
I tried a quick search for the office update you mentioned
and can't find it, I'll try looking again when I have more
time.
thanks!
 
Back
Top