Thread
:
Problem pasting numeric data from Access into Excel
View Single Post
#
2
Gordon
Posts: n/a
"JP Jones" <JP
wrote in message
...
I have recently upgrated from Excel 2000 to Excel 2002.
When I copy and paste a table from Access to Excel it stores all the
numeric
fields as text, even though they are properly formated in Access.
I did not have this problem with Excel 2000. Does anyone have any idea
what
is going wrong here?
Why are you copying and pasting the table? Just export it to xls format.
Easy.
Reply With Quote