<div>
So you need to do it in Access?<br />
<br />
You could do this using VBA and ADO in Excel.<br />
<br />
If you do need it in Access you could set up a pass through query to return the results, then export the results to Excel.
</div>


So you need to do it in Access?

You could do this using VBA and ADO in Excel.

If you do need it in Access you could set up a pass through query to return the results, then export the results to Excel.

<div>
Yes that is a possibility, but the user database is in SQL Server 2005. &nbsp;The DB has 1000 users worldwide.
</div>


Yes that is a possibility, but the user database is in SQL Server 2005.  The DB has 1000 users worldwide.

<div>
Which is a possibility?<br />
<br />
The pass through query in Access or pulling directly from SQL Server using VBA in Excel?
</div>


Which is a possibility?

The pass through query in Access or pulling directly from SQL Server using VBA in Excel?

<div>
I must pull diectly from sql server!
</div>


<div>
<div class="content wysiwyg-content">
I know there must be a way to write to &nbsp;cells within excel from sql Server. &nbsp;This is possible to do in access.<br />
<br />
I need VBA code (Function) that will write a stored procedure results to a user defined location on a excel workbook.<br />
<br />
Lets say the SP returns 6 records (each records contains five fields). &nbsp;I want to dump the results to cell &quot;A1&quot; or any other location in the workbook. <br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cell A1 &nbsp; Cell B1 &nbsp; &nbsp;Cell C1 &nbsp; &nbsp; &nbsp; Cell D1 &nbsp; &nbsp;Cell E1<br />
&nbsp; record 1 &nbsp;FName &nbsp; LName &nbsp; &nbsp; Address &nbsp; &nbsp; city &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;State<br />
&nbsp; record 2 &nbsp;FName &nbsp; LName &nbsp; &nbsp; Address &nbsp; &nbsp; city &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;State<br />
.<br />
.<br />
.<br />
&nbsp; record 6 &nbsp;FName &nbsp; LName &nbsp; &nbsp; Address &nbsp; &nbsp; city &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;State
</div>
</div>


I know there must be a way to write to  cells within excel from sql Server.  This is possible to do in access.

I need VBA code (Function) that will write a stored procedure results to a user defined location on a excel workbook.

Lets say the SP returns 6 records (each records contains five fields).  I want to dump the results to cell "A1" or any other location in the workbook. 

                  Cell A1   Cell B1    Cell C1       Cell D1    Cell E1
  record 1  FName   LName     Address     city          State
  record 2  FName   LName     Address     city          State
.
.
.
  record 6  FName   LName     Address     city          State

write SQL Server 2 Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.