Cutting and Pasting from Access XP to Excel XP 1

[tanenterp]

Hello,
When I cut and paste query or table results from Access XP (2002 SP2) into Excel 2002, my values are being copied over as text. This is even when the values are clearly number or currency fields in Access. I did not have this problem is any previous version of Access or Excel.

I know how to convert these values to numbers (I can just multiply all the values by 1, and it will convert to a number automatically) but that is a pain. Also, I can perform a simple addition (e.g. I2+I3) and get a valid answer, but a formula (=SUM(I2:I3)) does not give me an answer.

If anyone has any suggestions, please let me know.

Thanks!

 

[LNBruno]

Have you tried using the "Paste Special" in the Excel Edit menu?

< M!ke >

 

[tanenterp]

Thanks LNBruno!
It's very strange, when I do &quot;paste special&quot;, the default is &quot;Microsoft Excel 8.0 format&quot;. This format pastes the values as text. If I try ANY of the other special formats (Biff5, HTML, Unicode Text, Text, or CSV), it pastes the values correctly.

Has anyone else seen this issue, or have a possible explanation for this behavior?

Thanks again!!!

 

[tanenterp]

One other related question; is there a way to change the default &quot;Paste Special&quot; option, so that it does not default to &quot;Micosoft Excel 8.0 format&quot;? I would prefer to not have to remember to pick &quot;Paste Special&quot; each time, but have the &quot;regular&quot; pasting be in another format.

 

[LNBruno]

<<Has anyone else seen this issue>>
Yep, that's why I thought to suggest it

<<have a possible explanation for this behavior?>>
Because the Redmondians LOVE to throw curve balls!

<<is there a way to change the default &quot;Paste Special&quot; option>>

Not that I know of; but would sure like to hear if someone else has found a workabout for this &quot;feature!&quot;

< M!ke >

 

[tanenterp]

I finally found this issue addressed by Microsoft Knowledge Base:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328933

They say that they hope to fix it in the next service pack, but they can provide a non-guaranteed workaround in the meantime. I think I'll wait for the next service pack.

Thanks again!