I want to set up the import of data from an excel file into SQL Server
from my ASP.net (C#) application. The user will select the file that
needs importing.
I want to use DTS to do this. I was thinking of calling the DTS and
passing it the name of the file to import.
Is this the best way to do it? Any code available anywhere?
from my ASP.net (C#) application. The user will select the file that
needs importing.
I want to use DTS to do this. I was thinking of calling the DTS and
passing it the name of the file to import.
Is this the best way to do it? Any code available anywhere?