Create text file dump of SQL SP from Access

culminIT
culminIT used Ask the Experts™
on
Does anyone have an example of how I can create a text file dump of the results from a SQL Stored Procedure, run from Access?  I have an Access application that must run the SP in SQL and create a text file of the results.  My Access app is NOT a project, it's an mdb.

I know how to run the SP, but I need to know how to create the text file from there...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
- there are few methods available. normally i would use bcp function whereby i'll create a comma delimeted file and have control on data manipulation when writing it to the file:

- osql
- bcp
- redirection commands
- sp_MakeWebTask
- Com object calls

- all the methods is explain further in the following link:
http://www.nigelrivett.net/SQLTsql/WriteTextFile.html

Author

Commented:
No easy to follow for a beginner. Had to read up on the topic a lot apart from the solution provided.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial