<div>
No easy to follow for a beginner. Had to read up on the topic a lot apart from the solution provided.
</div>


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

<div>
<div class="content wysiwyg-content">
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? &nbsp;I have an Access application that must run the SP in SQL and create a text file of the results. &nbsp;My Access app is NOT a project, it's an mdb.<br />
<br />
I know how to run the SP, but I need to know how to create the text file from there...
</div>
</div>


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...

Create text file dump of SQL SP from Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.