Lyndsey has attended:
Excel VBA Intro Intermediate course
Exporting fixed width text file
Hi
I am trying to export a fixed width text file using a spec I have built. The field in the table is a text formated field (but is a number with no decimals) and when I view the data in the export wizard it looks as it does in the table (149).
The problem is once I have exported the data Access is adding decimals to the field.
RE: exporting fixed width text file
Hi Lyndsey, thanks for your query. I'm afraid you've noticed one of the many small but irritating quirks involved in getting data from one MS application to another. There is no application setting you can tweak to avoid this happening, but there are two work arounds; namely importing into an already formatted table in Access, or running Append queries on the imported data to reformat it. Details here:
http://www.pcreview.co.uk/forums/thread-3177847.php
I hope this helps, but let me know if you need any more assistance.
Anthony
RE: exporting fixed width text file
Hi Anthony,
It's actually when I'm getting data out of access rather than importing it.
I need to end up with a .txt fixed with file to load into the company AS400 database.
Lotus approach can do it but I'm loathed to go back to that!
