Export to Excel Issue

[Guest]

Hello. I'm using Access 97. I have a query used to export data to a .csv
file. The issue our users have is that Excel confuses some of the data and
converts the type incorrectly.

For example - one of the fields in the query export is called 'phase', and a
possible value in this field could be "5-5-1". However, Excel will convert
this into a date (05/05/01) when the user imports it or opens it in Excel.
I'd like to ensure the values in this (and other similar) fields are exported
as text.

Is there a function to trap these values to ensure that they are recognized
as text values when imported into Excel?

Thanks in advance.

 

[Steve]

Set the range in Excel to text before exporting.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)