OutputTo truncating text file

When using the command:

DoCmd.OutputTo acOutputFunction, "SQLfunctioncall", acFormatTXT, "filename"

The results are truncated as shown below:

---------------------
| Data |
---------------------
| PRCG,AreaAp8,27-A |
---------------------
| PRQT,MALL003386,0 |

Results are also not truncated when output to Excel or when the function is run directly in Query Analyzer.

Front end: Microsoft Access Project 2003
Back end: SQL Server

Any help would be appreciated,
Cathryn

Oct 6 '06 #1

Subscribe Post Reply

2607

PEB

1,418

Expert 1GB

Hi Cathryn,

In fact it isn't obvious where is the truncation... A part of your text isn't exported to txt? Or simply the columns in the table aren't arranged as real table in txt format?

Best regards!

Oct 8 '06 #2

Cathryn

Hi PEB,

The data needs to go into a comma delimited file, but different rows have a different structure, therefore the function creates the correct structure and exports a single column table in the correct order. This single column has been truncated. The full version of the first few rows is shown below.

PRCG,AreaAp8,27-Aug-06,156126.99,M253, ,20060827, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRQT,MALL003386,001,7,27-Aug-06,0,M253, ,MEFT,INVC, ,20060827,M1,AUD,0,0,0,2008.90,27-Aug-06,0, ,N, ,N,AreaAp8,20060827, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRLN,MALL003386,001,7,27-Aug-06,0,1, ,1826.27, , , , , , , , , , , , , , , , , , , , ,GST,G11,Full, , , ,M253,481200,900,800,20, , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRTX,MALL003386,001,7,27-Aug-06,0,GST,182.63, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRQT,MAND003387,001,EMU8,27-Aug-06,0,M253, ,MEFT,INVC, ,20060827,M1,AUD,0,0,0,3653.57,27-Aug-06,0, ,N, ,N,AreaAp8,20060827, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRLN,MAND003387,001,EMU8,27-Aug-06,0,1, ,3321.43, , , , , , , , , , , , , , , , , , , , ,GST,G11,Full, , , ,M253,481200,900,800,20, , , , , , , , , , , , , , , , , , , , , , , , , , ,
PRTX,MAND003387,001,EMU8,27-Aug-06,0,GST,332.14, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Many thanks,
Cathryn

Hi Cathryn,

In fact it isn't obvious where is the truncation... A part of your text isn't exported to txt? Or simply the columns in the table aren't arranged as real table in txt format?

Best regards!

Oct 9 '06 #3

PEB

1,418

Expert 1GB

So if I understand well, you put in one column all the information from a table, and your separator is the coma...

But the export in txt fails with commas!

And exports only the first 10-20 symbols... Strange seems like a limitation of variable or text that is limited to a certain length!

Why do not try to do the export programticcally in this case it should work as you want!

Best regards!

Oct 14 '06 #4

by: Frank Barnhart | last post by:

We have an application which runs Access under automation. With Access 97, the app included this line to send a report to a text file: myAccessObject.DoCmd.OutputTo acOutputReport, ,...

Microsoft Access / VBA

Endless output using OUTPUTTO MsWord

by: Mal | last post by:

Hi, I have a button on a form that outputs a report to word. While it has been working well for a while, today it is not. The behaviour now is that it endlessly outputs pages to word. There...

Microsoft Access / VBA

DoCmd.OutputTo vs. Macro Sheet

by: tmountjr | last post by:

I've got a user who's trying to export a text file with unicode formatting. When he exports it as straight ascii, some of the foreign characters (mostly just accent marks and the like - no...

Microsoft Access / VBA

How to use OutputTo with named query?

by: deko | last post by:

When using OutputTo with a query, the 'File name' window in the 'Output To' dialog gets populated with the name of the query by default. This makes the exported file self-describing if the query...

Microsoft Access / VBA

Looping Issue with DoCmd.OutputTo

by: Ryan | last post by:

Hello. I was hoping that someone may be able to assist with an issue that I am experiencing. I have created an Access DB which imports an Excel File with a particular layout and field naming. ...

Microsoft Access / VBA

Formatting File Names for OutputTo

by: dancole42 | last post by:

I have a question regarding the DoCmd.OutputTo function. I have an invoice report that shows all of the invoices for a particular date. I want to create a button that will export each page of...

Microsoft Access / VBA

Behaviour of the DoCmd.OutputTo

by: Simon | last post by:

Dear reader, With the DoCmd.OutputTo ...... you have the possibility to write a report to an external location. In case the external location is an existing file the DoCmd is not...

Microsoft Access / VBA

Use of OutputTo for a report with a Where condition

by: Jim Devenish | last post by:

I have a report which can be displayed on the screen with: DoCmd.OpenReport "RemittanceAdvice",acViewNormal,,"PaymentID = " & paymentRecID I now wish to create a snapshot of this, using the...

Microsoft Access / VBA

OutputTo RTF Problem - Access 2007

by: Icarus | last post by:

I have a function in Access 2007 that runs the following code: DoCmd.OutputTo acOutputReport, "rpt-TOC Summary", "Rich Text Format (*.rtf)", "C:\TOC\Working\PRE-X08-0295.doc", False When I run...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

AI Job Threat for Devs

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,...

Career Advice

Similar topics