[AccessD] Exporting a stored procedure to csv file

Sorry about the confusion.  It is the results of a stored procedure that I
want to export as a csv file.  The stored procedure returns a set of rows,
the 2 parameters are used to filter what rows are included.
The previous way I have done this is to use the stored procedure to fill in
a table and then export the table.  Just wondering if there is an easier
way.  With an adp there was a simple command but this doesn't seem to work
with an accdb:
    DoCmd.OutputTo acOutputStoredProcedure, "EXEC
dbo.spsfrFDClaimScheduleCreate " & Me!cboFilter, acFormatTXT, strFullName
David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Button
Sent: Saturday, 6 September 2014 11:39 p.m.
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Exporting a stored procedure to csv file

I's say you shouldn't
Data goes to csv as the values (usually) are of varying length in different
rows and need to be separated, hence Comma separated values

A procedure would (I expect) to be a script of 1 or more text lines where
the words and values in the lines of the script need to be kept as part of
the single entity that is the code line.

So - then we get to your 2 parameters - ???

JimB

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Saturday, September 06, 2014 4:51 AM
To: AccessD
Subject: [AccessD] Exporting a stored procedure to csv file

Hi listers,
Having a brain dead moment.  How do I export a stored procedure with two
parameters from Access using vba into a csv file?
Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com