User Profile
Collapse
-
Great thanks! This seems to have done it! -
Export from Access to .txt - losing positional holders
I am trying to export a table to a text file. The problem I am having is that by putting it into .txt I lose my positional holders.
i.e. The field size for field A is set to 8. User enters 1234 and the format is set so that it is displayed as 00001234. When this is exported, it is exported as 1234. The preceding zeros are knocked off.
How can I export a table to .txt and keep the zeros?
Any suggesti...
No activity results to display
Show More
Leave a comment: