Maintaining Datatypes When Exporting to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
Back
Top