LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
JP Jones
 
Posts: n/a
Default

I could do that, but copying and pasting is quicker, and it irks me that
Excel 2002 cant do something simple that Excel 2000 could do.

I suspect this is a bug in 2002, so I'm sure there is a quick fix out
there.... if only I could find it.



"Gordon" wrote:

"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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM
populating data from excel into access Chris Links and Linking in Excel 1 December 15th 04 07:50 AM
Data population between excel and access - Errors on missed fields Chris Excel Discussion (Misc queries) 0 December 13th 04 11:55 AM
Problem Code: Retrieving Stored Access 03 Query Bettergains Excel Discussion (Misc queries) 2 December 7th 04 04:11 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"