C
Craig
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.
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.