Export to txt include .00 after all numbers

  • Thread starter Thread starter Bill Board
  • Start date Start date
B

Bill Board

I am using Access 2007 and I don't understand when I export a table to a txt
file (a pipe delimited file) all the values like zip codes have .00 after
them. For example if the the zip code was 33611 the file would have 33611.00
doens't look like that on the screen.. What gives?
 
Hi,

I would guess that you designed the field to be a single or double
number. Make a backup first and then change the field type to long integer.
Or, better yet to a twelve-character text field which should accomodate
all(?) the various postal code formats in the world. If you change to text,
you will need to add zeroes to the beginning.

update table
set zip_code = String(5 - Len(zip_code), "0") & zip_code
where Len(zip_code) < 5;

Clifford Bass
 
Back
Top