troubleshooting Question

Create text file dump of SQL SP from Access

Avatar of culminIT
culminITFlag for South Africa asked on
Microsoft AccessMicrosoft SQL Server 2008
2 Comments1 Solution335 ViewsLast Modified:
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...
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros