473,802 Members | 1,937 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Output To vs. Transfer Text Options

This is just a general question (Access 97). For exporting text from an
Access database to another one, what would be the
advantages/disadvantages of the two output/transfer methods? Is one
more reliable/consistent than the other? If they are comparable, what
is the reason for having two separate methods? Any opinions will be
appreciated. Thanks.

Nov 13 '05 #1
1 1930
Originally, TransferText was a wrapper for a Jet append query.

OutputTo was a code loop that looped through a form, report
or recordset and read the field/control values and copied them
to a file.

I think that is still the case.

The reason was that Jet append queries were easy and simple,
but couldn't be used to output a form or report.

I can't think of any advantages/disadvantages, except that
they are slightly different, and can sometimes only one of
the two is easily available.

(david)
"Rolan" <co******@saf e-mail.net> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
This is just a general question (Access 97). For exporting text from an
Access database to another one, what would be the
advantages/disadvantages of the two output/transfer methods? Is one
more reliable/consistent than the other? If they are comparable, what
is the reason for having two separate methods? Any opinions will be
appreciated. Thanks.

Nov 13 '05 #2

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

Similar topics

6
1770
by: M.E. | last post by:
I have explained at the linked below my problem. Basically it is a Java code .. It is a dropdown box. when you select an item it goes to another text area .. You can add items to that text area. Problem is when I summit it only submits the first item in the textbox ignoring other items. How can I get it to post all the items in the textbox (it is not really a text box, you need to have a look. Actual page suing this code is here....
11
6641
by: Abhishek | last post by:
I have a problem transfering files using sockets from pocket pc(.net compact c#) to desktop(not using .net just mfc and sockets 2 API). The socket communication is not a issue and I am able to transfer data across.On the serve I am using Socket 2 API (recv function to read bytes)and not using ..NET. I use FileStream to open the file on the pocket pc, then associate a BinaryReader object with the stream and call ReadBytes to read all the...
1
2711
by: olduncleamos | last post by:
Hello all. With a background in ASP, I am finding the work required for passing values between pages mystifying. For various obvious reasons, I have eliminated using cookies and session to store state data. The only ASP.NET options left is to use the Server.Transfer to transfer to page 2 from page 1, and then use the context to get whatever values in page 1 from page 2. I do find this indeed a very elegant solution as now I can pass...
4
1926
by: astromac | last post by:
I'm new to php and was wondering if the following was possible... I would like to have a list of items loaded from a text file, process each item in the list and then return the processed result to a new window so that the new window displays the results, one by one, until it is done processing the list. I considered javascript but the whole client-side/server-side divide seems difficult for this newbie to figure out. Is what I want...
3
12558
by: imrantbd | last post by:
This is my first problem.Please help me. I have the following code: <head> <script language="JavaScript"> function addSrcToDestList() { destList1 = window.document.forms.destList; srcList = window.document.forms.srcList;
3
8720
by: imrantbd | last post by:
I need array type name like "destList" must use for my destlist select box,not a single name.Or need a solution to capture multiple value of "destList" select box and send all selected value in php page.The multiple select value then insert in database added by comma.The following is my code: Form Page:form.php <head> <script language="JavaScript"> function addSrcToDestList() { destList1 = window.document.forms.destList; srcList...
4
2058
by: rn5a | last post by:
Assume that there's a website named www.abc.com. There are 2 ASPX files & one MS-Access database file in this site. The 1st ASPX file is named "SearchForm.aspx" & the 2nd ASPX file is named "SearchResult.aspx". "SearchForm.aspx" houses a Form with a select list & 2 TextBoxes. The select list is populated from a Access database table. When the Form is submitted, the user is taken to "SearchResult.aspx" which retrieves & displays the...
0
1705
by: grant | last post by:
I have a transfer data task that gets some data from a table and outputs it to a pipe delimitd text file. How can I configure a transfer data task so it outputs the field names from the table in the first line of the output file Thanks in advance Grant
11
1751
Banfa
by: Banfa | last post by:
OK so last night I decided to upgrade my Kubuntu installation release from 7.04 (Gutsy Gibon) to 8.10 (Hardy Heron) because as someone pointed out 8.04 is a LTS release. Starting the install was simplicity because the Update Manager simply asked if I wanted to. A couple of hours later everything was good to go and I restarted and that is when it all when pear shaped. Trying to get my Nvidia card drivers reinstalled correctly again was a...
0
9699
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
9562
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
10305
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...
1
10285
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9115
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6838
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
5622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3792
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2966
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.