Clipboard problem

[Laurie lawrence]

I'm trying to copy numbers from an Access 2000 query to
Excel running on XP. The numbers have 4 decimal places
but are stored in the clipboard to 2 decimal places.
Doesn't matter how I format the query/table numbers, I
can't paste them into Excel with the correct number of
decimal places.

Any ideas, please

 

[Ken Snell]

Export the records to EXCEL using
(1) File | Export
or
(2) Use macro or VBA code and use the TransferSpreadsheet method.

It appears that ACCESS is using its ".csv" default formatting when copying
to clipboard (default for decimals is 2 decimal places).

 

[Laurie Lawrence]

Thanks Ken

Worked a treat

Laurie

-----Original Message-----
Export the records to EXCEL using
(1) File | Export
or
(2) Use macro or VBA code and use the TransferSpreadsheet method.

It appears that ACCESS is using its ".csv" default formatting when copying
to clipboard (default for decimals is 2 decimal places).
--

Ken Snell
<MS ACCESS MVP>




.

 

[Beth Melton]

Hi Laurie,

Also, in the future you can go to Tools/Office Links/Analyze it with
Excel (or select the query in the database window and use the Office
Links command on the toolbar) to automatically export the query
results to Excel.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/