query export wont allow a zero value?

  • Thread starter Thread starter Vadimbar
  • Start date Start date
V

Vadimbar

I runa query and forcing a specific value with a leading zero.
i.e. 011210

When I run the export the first zero is eliminated. 11210

Any ideas why this happens? When ever I change the zero to a 1 or 2 works
perfectly.

The query always shows the correct value but the export text file is always
off. Any ideas why?

Thank you
 
If you are exporting to Excel, and this should be a text field, prepend a
single-quote to what you are exporting. Then Excel will keep the text
formatting.
 

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 to text file cuts my leading zeros off. 4
Force text field to numeric field? 2
exporting to fixed width text file, need to keep leading zeros 0
Exclude Multiple Zeros in Query 4
Fill Blanks with Zero on CrossTab 4
Data/Values change when Query Analyzed in Excel 3
Export number without decimals 1
Counting trailer numbers 2

Back
Top