Numeric to text conversion

[Dave]

I recently upgraded from Office 2000 to Office 2002. In
2000, when copying from Access tables and pasting into
Excel, the data type integrity was maintained, that is,
text, date, and numeric fields came over into Excel in
that defined format. With 2002, all my numneric fields
are converted to text and I'm flagged that numbers are
stored as text from the error checking function.
Converting is a major headache and exporting the Access
tables into Excel, though this does maintain data
integrity, is not what I need to do in most cases.
Question is, is there a way to modify defaults in Excel
and/or Access 2002 to make it behave like 2000 as far as
copying and pasting data from Acess tables to Excel
spreadsheets?

 

[Dave Peterson]

Debra Dalgleish posted a manual fix and a macro (from Jon Peltier):

http://groups.google.com/[email protected]

 

[Debra Dalgleish]

And she more recently posted this <g>:

'=============================
If you're using Excel 2002, the problem with Access data has been fixed
in Office XP Service Pack 3. There is information in the following MSKB
article:

Numbers that are copied from Access 2002 paste as text in Excel 2002
http://support.microsoft.com/default.aspx?id=328933
'==========================

And there are a variety of methods for converting text to numbers here:

http://www.contextures.com/xlDataEntry03.html

 

[Dave Peterson]

That should make life a little easier for the OP.

(I hope I can remember it when/if I respond to an Access question again!)