Maintaining Datatypes When Exporting to Excel

[Guest]

I have table in Access with a column with a data type set to "Number". When
I export the data to Excel I want to maintain the data type as numeric.
Instead, after the data is exported to Excel, the data seems to be changed to
text, even if I change the format to "Numeric". The only way to convert the
data to numeric is to press F2 in each cell and press "Enter".

How can I export a Number format from Access to Excel without having to
press "Enter" in each cell?

 

[Armando Blanco]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Armando Blanco
Microsoft MVP

 

[Jeff Boyce]

Disregard the "cant do this with Access" message. It is SPAM (or worse).
Follow the link at your own peril...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Nurick]

This is not normal if you are exporting an ordinary numeric column.
Please give details, including some of the numbers showing how they
appear in Access and Excel.

Are you exporting the table, or a query based on the table? If the
latter, please post the SQL of the query.