Export to Excel Issue

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

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Export Issue 5
Multivalue field and exporting to Excel 1
Export to excel has character limit 3
Best Ways to Convert OST to PDF? 1
How to convert OST to PDF? Simple Methods 2
export query with formulas to excel 2
Fixed Numbers 3
Exporting query to XL is truncating field data 7

Back
Top