98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Exporting fixed width text file
Exporting fixed width text file
Resolved · Medium Priority · Version 2003
Tue 19 Oct 2010, 12:55Delegate Lyndsey said...
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.
Fri 22 Oct 2010, 16:10Trainer Anthony said...
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
Wed 27 Oct 2010, 12:20Delegate Lyndsey said...
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!
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
