By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

OutputTo truncating text file

P: 2
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
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
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

P: 2
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
Expert 100+
P: 1,418
PEB
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

Post your reply

Sign in to post your reply or Sign up for a free account.