Export To Excel Data Changing

  • Thread starter Thread starter pas926
  • Start date Start date
P

pas926

I'm using Microsoft Access and Excel 2003 and when I export a report from
Access to Excel some of the data from the report is changing when it gets to
Excel. For example "4a" turns into "0.166666666666667", "0-10" turns into
"36800". Other numbers and text combinations don't change so I'm at a loss
as to how to fix this. Any help would be greatly appreciated. Thanks in
advance.
 
Hi

Here is an answer posted previously by Jeff Boyce which may help with your
formatting for export.

<When exporting data from Reports to Excel, the data is not properly
formatted.



Create a query that returns the data. In the query, use the Format property

and function, and the "conversion" functions (CDate(), CInt(), etc.) to

coerce the data to be in the format you wish exported.



Then export the query.



--

Regards



Jeff Boyce

Microsoft Office/Access MVP





Jeanette Cunningham
 
Back
Top