Unanswered: Creating CSV Files through MS-SQL Server 2000 - Stored Procedure
I have tried to create a CSV File and to be stored in the Client Machine.
I have created a "VB - DLL" to select the records from the SQL Server and create the CSV File and store it in the Client Machine using the Host Name/Shared Folder.
I want to know how to create the object for the DLL and call a DLL Method from the Stored Procedure. I am working with MS-Access Report which will pass parameters to the Stored Procedure mapped to it. All I want to know is the way to create the object for the DLL and call a DLL Method from the Stored Procedure.
If anyone can help in this, it will be very helpful for me to finish my job.