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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-15 : 08:44:32
|
| matt writes "Is there a way where I can have someone browse and find an .xls file and upload the contents of the file into a table in mssql 2000?" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-15 : 09:26:18
|
| Matt,There are various free upload components, my preference is aspupload because of the progress bar, good support and advanced features.www.aspupload.comOnce the file has been uploaded you can run a dts package which takes the data in excel an imports it into a stagging table for manipulation. Next you can run stored procedures to manipulate your data into its final stage and insert it into your destination table.For more info on dts packages do a search on this site. |
 |
|
|
|
|
|
excell to sql via the web