XP: copy/paste from Access into Excel

S

sparklingsilvy

Hello

I am converting lots of Access/Excel apps to the XP version and I hav
problems with the most stupid issues.
Here is one of them:
in the previous version (under NT) I could just copy and past
tables/queries from Access into Excel (Crtl C/Crtl V) and everythin
was working.
Now the numbers are all formatted as text in Excel unless I past
special (Biff5).
I know I could use the Tools--> Analise it with Excel (from Access t
Excel) but this opens the results in a new sheet and sometimes I nee
to paste in a specified region of existing spreadsheets.
Yes, I could also use pass through query from Excel to Access but mos
of this copy and paste happen spontaneously (on demand, whe
investigating problems with the figures) so I cannot always use smar
SQL.

I bet there is a simple setup somewhere.
Help!!!
 
Top