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