Export SQL User-Defined Function or SQL View From ADP?

  • Thread starter Thread starter Kevin McCall
  • Start date Start date
K

Kevin McCall

I know I can use DoCmd.TransferText to export a table to
fixed width or comma delimited format text file but I
haven't found a way to export a SQL view or user-defined
function from an Access XP .adp. I have even tried
DoCmd.OutputTo and that comes a little closer but then I
don't have a choice in how it gets formatted. The data is
exported in a type of grid. The only thing I can think of
as a workaround is to create a SQL table that I can
append records to, export via DoCmd.TransferText and then
truncate the SQL table for reuse when I'm ready to export
again.

Is there a way that I can export the results of a SQL
user-defined function and/or a SQL view (or even a stored
procedure) to a comma-delimited or fixed width text file
on my local machine? I'm looking for a DoCmd method or
something similar or any other creative ideas that might
work.

Thanks in advance,
Kevin McCall, MCSD
 
Back
Top