Using OutputTo

  • Thread starter Thread starter Jeremy Ames
  • Start date Start date
J

Jeremy Ames

I have several queries that I export into an XLS format in a loop using the
OutputTo function. The process itself works fine, however it does seem to be
changing some of my data. I have a text field that contains information such
as "LD $5.95 - 12 mth," and there are several others like that. When I use
the OutputTo function to return data such as that, I get "mth". When I
manually export the query, (right clicking on the query and selecting
export) the file comes out normally. I have no idea how to work around this.

Can someone please help? I need to find a solution for this soon. I am
working on a short deadline here.

Thanks for your assitance,

Jeremy Ames
 
I have several queries that I export into an XLS format in a loop using
OutputTo function. The process itself works fine, however it does seem
changing some of my data.
Click to expand...

Yes, XLS export is like that........

I suggest

1) Don't loop through XLS export.
2) Always copy to a temp table, and export the table contents instead of
using a query
3) Try using
Application.dbEngine.Idle
Application.dbEngine.BeginTrans
OutputTo .....
Application.dbEngine.CommitTrans dbFlushOSCacheWrite

(david)
 
How would you suggest that I run reports for several people if I am not
supposed to loop through the export?

david epsom dot com dot au said:
I have several queries that I export into an XLS format in a loop using
OutputTo function. The process itself works fine, however it does seem
changing some of my data.
Click to expand...

Yes, XLS export is like that........

I suggest

1) Don't loop through XLS export.
2) Always copy to a temp table, and export the table contents instead of
using a query
3) Try using
Application.dbEngine.Idle
Application.dbEngine.BeginTrans
OutputTo .....
Application.dbEngine.CommitTrans dbFlushOSCacheWrite

(david)
 
I'm sorry, my experience of XLS export is that it works well for
a small amount of records, done slowly, but badly for a lot of
records, done fast.

You can try the other ideas I suggested to see if they help.
Also, you can try to use an SQL export instead of OutputTo.

(david)
 
Back
Top