Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 importing excel spreadsheet into SQL thru the web

Author  Topic 

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2003-05-06 : 21:19:50
I've got a requirement to upload an Excel file through a web form which gets imported in SQL and I'm not sure quite how to do it. I know how to import a file the web but is there a way to kick of a DTS job programatically after the file is uploaded?

The web is asp.net using vb. The database is SQL 2K. Any advice on the best approach?

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-05-06 : 21:24:36
Using DTS object.

http://www.sqldts.com/default.aspx?6,104,104,5,1

Go to Top of Page

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2003-05-06 : 21:39:29
This looks promising - thanks!

Go to Top of Page
   

- Advertisement -