What would be the method for creating a text file from a table where some of the information in the table is variable lengths (i.e. currency) but the text file starting character positions for those fields is fixed? (Example: The text file needs the currency field to occupy positions 11-25 but the amount is 1126.25 and that entry needs to be right justified and space-filled.)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access table export to text file (currency)
- Thread starter Oliversmo
- Start date
- Status
Similar threads
- Question
- Question
- Locked
- Question