473,626 Members | 3,247 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Wrapping Text - Export from Access to Text File

I'm trying to export an Access table to a pipe-delimited text file (with no
text qualifier) and it keeps wrapping the text for one of the tables. None of
the fields are particularly long, so I'm not sure why it's doing this. Any
ideas how I can stop it from wrapping the text in the text file?

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200803/1

Mar 19 '08 #1
1 3032
Leviathan wrote:
>I'm trying to export an Access table to a pipe-delimited text file (with no
text qualifier) and it keeps wrapping the text for one of the tables. None of
the fields are particularly long, so I'm not sure why it's doing this. Any
ideas how I can stop it from wrapping the text in the text file?
Nevermind, figured it out. Looks like there was a carriage return in defining
one of the cells in the query.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200803/1

Mar 19 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3160
by: JJ | last post by:
Hi, usually, I'm not using MS servers, but I have a big problem with a Access table. I should create a web application for a Historical Dipartment. They have created a populated a Access database using unicode compression field (for ancient language). I would like to export this table into MySQL o Postgres, but it's
1
2491
by: Newbillian | last post by:
I am getting an error msg saying: The formats that enable you to output data as a Microsoft Excel, rich-text format, MS_DOS text, or HTML file are missing or incorrectly registered in the Windows Registry. The error number is 2281. I am using the sendobject function to export the contents of a query in text format. I have installed every possible option in the Office XP installation. It reminds me of the old "can't find installable...
3
25027
by: sam | last post by:
Can you teach me how to export access file to excel file in VB.net? Thank in advance.
7
1683
by: Ramon Pam | last post by:
I need create a macro for export to only one text file, of 3 TABLES What is the necessary instructions (for create ONLY ONE FINAL text file) ?? Thanks Ramon
1
2677
by: Wandering | last post by:
I know you guys are heavy duty coders, while I do ad-hoc analysis, and rarely write code. And, I may be in the wrong groups because this is about an install issue, and I don't think it's a code issue. But ... Office 2000 was on this machine when it was given to me. I don't own it. After installing Office 97, mine, in a different directory, and checking most of it out, I uninstalled Office 2000. Well, it's a lot easier to upgrade than...
2
9608
by: nuhura01 | last post by:
Hi.. I'm trying to save query path which is in text box to text file. Below is the coding that i'm using currently: Private Sub SaveQueryPath() 'save to text file Response.Clear() Response.Buffer = True Response.AddHeader("content-disposition",
0
1778
by: imranabdulaziz | last post by:
Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2005 as a back End I generated local mode report but as there was no printing option available . I assign printing feature to button click by exporting the data to EMF format and print Now when I run it through IDE VS2005 then it does not show any error. But when I run in through IIS in intranet it showing me this error The process cannot access...
0
2108
by: JFKJr | last post by:
Hello everyone! I am trying to export Access table data into Excel file in such a way that the table field names should be in the first line of each column in excel file followed by field data, and should start from column B in excel. The column A of the excel file should have heading "Extract Policy" followed by checkboxes so that the user can check which policy to extract after downloading the excel file. Can anyone suggest me how to do...
3
2176
by: grumpydadtl | last post by:
How can I name a text export using periods in the file name: ABC.D31.HBCVF.txt.rbd31 as opposed to something like "Export.txt"? Each time I try, Access changes the text export file name to: ABC#D31#HBCVF#txt#rbd31
0
8269
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8203
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8642
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8512
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5576
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4094
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4206
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2630
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1515
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.