UtterAccess Discussion Forums
  UtterAccess Home  | Forums Index  | Search  | Links DB  | FAQs   
Microsoft® Access help forums plus Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online and... many more!
Forums Index My UA Who's Online Login Become a UA member now! This is free & confidential!

Access UtterAccess!
New? Welcome!
Join UA here!

Members Login


Password


Remember me!


Search The Database
Advanced Search

Google
Web UA

More Links

  UtterAccess Links
  Link to UtterAccess
  Call UtterAccess Home
  Add UA to Favorites

Quick Jump

UA Recommended
Access 2007

Access Team Blog
•  Get the latest information
    directly from the
    Microsoft® Access
    Product Team!

Access Team Blog

Get the latest information directly from the Microsoft® Access Product Team!


UA Recommended
UA's own Grover Park George on Access

UA's own ScottGem and datAdrenaline!

Servers tuned by
Vaultechnology
Carriage return in exported text file

●  Carriage return in exported text file  Version: 2000 (9.0)

Posted on 03/17/07 11:29 AM
Posted by john123allen - New Member
Posts: 3 -

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
Novice Access user. I have a long report of 200 lines and 30 to 40 characters each line, pulled from a complex query. When I export it to a text file for a required transmission there are unwanted carriage returns in the text file. I do not use the Wizard and it cannot be and is not a delimited or fixed length file. Would appreciate some help.

Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 03/17/07 11:53 AM
Posted by ace - Utter Access VIP
Posts: 4369 - Loc: Upstate NY, USA

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
So you're just right clicking the query and selecting export?
Are there also carriage returns that are wanted?

--------------------
Just because you are a character doesn't mean that you have character.

●  Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 03/17/07 12:31 PM
Posted by john123allen - New Member
Posts: 3 -

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
I run my report. It looks fine. Go to file. Click export. Save as type. Click text file. Open the text file and there are carriage returns every 5 to 6 lines. There are no carriage returns appearing in the report before it is exported to the text file.

●  Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 03/17/07 05:26 PM
Posted by VanThienDinh - Utter Access Editor
Posts: 13608 - Loc: Sydney, AUSTRALIA

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
Try exporting the data from the Source Query instead of the Report ...

--------------------
Van T. Dinh


●  Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 03/17/07 09:38 PM
Posted by john123allen - New Member
Posts: 3 -

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
I can not send directly from the query. The Report massages the data into a flat file just the way the EDI recipient wants it. That is except for the emply lines caused by the unwanted carriage returns.

●  Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 03/17/07 11:16 PM
Posted by VanThienDinh - Utter Access Editor
Posts: 13608 - Loc: Sydney, AUSTRALIA

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
If your data can be massaged in the Report, it should be possible to massage the same data in a Query.

Perhaps you should post a sample copy of the database with the Report you want to output and see if anyone can massage the data using a Query ...

--------------------
Van T. Dinh

●  Re: Carriage return in exported text file  Version: 2000 (9.0) [Re: john123allen]

Posted on 05/03/07 09:54 AM
Posted by brett_hinman - Utter Access Veteran
Posts: 433 - Loc: Omaha, NE

Forum: Access Reports 		• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator

• Top of page
Did you ever get this resolved? I'm having the exact same problem.

Page Jump
Pages: 1

Navigate
Post List
Previous thread Previous
Next thread Next

Thread Options & Info
• Threaded
• Print Thread

• 728 Thread views

Page Jump
Pages: 1
©2009 UtterAccess.com. All rights reserved.    Privacy Policy    UA Cookies    Top

Delivered to you by Shiny New Too Server in 0.023 seconds. 0.004 seconds to process 15 queries. Zlib compression enabled.