Dec 3, 2005 #1 mlynch199 IS-IT--Management Dec 3, 2005 3 GB Can I create a stored procedure in SQL which will write data form the database into an existing excel file which will run a macro and can be appended?
Can I create a stored procedure in SQL which will write data form the database into an existing excel file which will run a macro and can be appended?
Dec 6, 2005 #2 rac2 Programmer Apr 26, 2001 1,871 US Seems likely that something close can be accomplished if not exactly what you describe. You may get a better response in the Microsoft SQL Server or the Excel forum. Upvote 0 Downvote
Seems likely that something close can be accomplished if not exactly what you describe. You may get a better response in the Microsoft SQL Server or the Excel forum.