Dec 3, 2005 #1 mlynch199 IS-IT--Management Joined Dec 3, 2005 Messages 3 Location 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 Joined Apr 26, 2001 Messages 1,871 Location 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.