p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ASP.NET 1.0 and 1.1 Professional (http://p2p.wrox.com/forumdisplay.php?f=57)
-   -   To upload an excel file to to sql server. (http://p2p.wrox.com/showthread.php?t=38789)

Abins February 21st, 2006 05:07 AM

To upload an excel file to to sql server.
Hi friends,

I wnt 2 upload an excel file Through ASP.NET and transfer all datas into sqlserver. If you can provide step-by-step way...it will be the best.

thanking you,


muskaanbajaj February 21st, 2006 05:13 AM

Hi Saas,

You can try using HTMLInputFile control, which automatically opens a dialog box to select the file to upload.
And then you can do ur coding.
You can try searching it on net.

Next, you need to save that file on ur machine and then use it.
You can use DTS package or XML file to upload it in the Database.

Try doing it.
Incase of any query, let me know.

I too have worked on i recently using XML file.
But i wud suggest you to use DTS package.


gowthamsen February 22nd, 2006 01:21 AM


Gowtham Sen

All times are GMT -4. The time now is 07:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.